| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
