How to change text into number?

E

Eric

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
 
N

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
 
F

Fred Smith

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

=a1+0

should do the trick.
 
P

pinmaster

Hi,

Or if the value is inside quotes then:

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

Cheers!
Jean-Guy
 
R

Rick Rothstein \(MVP - VB\)

Or if the value is inside quotes then:
=MID(A1,2,LEN(A1)-2)*1
Click to expand...

Just offering another possibility for consideration...

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

Rick
 
Top