View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How to change text into number?

=--(A1) or =VALUE(A1)
--
David Biddulph

"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