How to change text into number?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

In cell A1, there is "1,425.06B".
=SUBSTITUTE(A1,"B","")
Once I remove the B in cell A1, and it return 1,425.06 in cell B1.
When I click the -> .0 button to hide the last two digits, it does not work.
Maybe it shows as a text rather than a number.
Does anyone have any suggestions on how to change this text into number? so
I can use the button -> .0.
Thanks in advance for any suggestions
Eric
 
In cell A1, there is "1,425.06B".
=SUBSTITUTE(A1,"B","")
Once I remove the B in cell A1, and it return 1,425.06 in cell B1.
When I click the -> .0 button to hide the last two digits, it does not work.
Maybe it shows as a text rather than a number.
Does anyone have any suggestions on how to change this text into number? so
I can use the button -> .0.
Thanks in advance for any suggestions
Eric
Click to expand...

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

should change it to numeric if what you write is so.
--ron
 
Hi Eric
The formula to change text to number is =VALUE(C1)and to check if its
formated has number type =isnumber(c1) it should return ( TRUE)
Regards
Cimjet
 
Back
Top