How to change text into number?
 

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

How to change text into number?
 

Eric,

See if =VALUE(A1) will work for you.

HTH,

Conan




"Eric" wrote in message
...
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

How to change text into number?
 

On Thu, 28 Feb 2008 16:44:01 -0800, Eric
wrote:

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

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

should change it to numeric if what you write is so.
--ron

How to change text into number?
 

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
"Eric" wrote in message
...
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

How to change text into number?
 

=SUBSTITUTE(A1,"B","")*1


Gord Dibben MS Excel MVP

On Thu, 28 Feb 2008 16:44:01 -0800, Eric wrote:

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