View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default How to change text into number?

To change text to a number, just use it in a formula with arithmetic. So

=a1+0

should do the trick.

--
Regards,
Fred


"Eric" wrote in message
...
Does anyone have any suggestions on how to change text into number?
For example, in cell A1, the value is "13.555", and I would like to display
13.555 in cell B1 as a number.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric