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: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Did adding zero to the value not work?
=VALUE(B2)+0
Reply With Quote