Hi,

Or if the value is inside quotes then:

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

Cheers!
Jean-Guy

"Eric" wrote:

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