How to change text into number?

[Guest]

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

 

[Niek Otten]

Hi Eric,

In B1:

=A1*1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Fred Smith]

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

=a1+0

should do the trick.

 

[David Biddulph]

=--(A1) or =VALUE(A1)

 

[Guest]

Hi,

Or if the value is inside quotes then:

=MID(A1,2,LEN(A1)-2)*1

Cheers!
Jean-Guy

 

[Rick Rothstein \(MVP - VB\)]

Or if the value is inside quotes then:

=MID(A1,2,LEN(A1)-2)*1

Just offering another possibility for consideration...

=--SUBSTITUTE(A1,"""","")

Rick