| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| how to change the number value to text value | Excel Discussion (Misc queries) | |||
| Change number format from text to number? | New Users to Excel | |||
| Change Text to a number | Excel Worksheet Functions | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Hybrid Mode
