Thread: Reliable way to convert text to number with a formula
View Single Post
 
Old 12-19-2019, 01:49 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Did adding zero to the value not work?
=VALUE(B2)+0
Reply With Quote