View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How to change text into number?

Hi Eric,

In B1:

=A1*1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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