| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change text into number?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change text into number?
Hi Eric,
In B1: =A1*1 -- Kind regards, Niek Otten Microsoft MVP - Excel "Eric" wrote in message ... | 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change text into number?
To change text to a number, just use it in a formula with arithmetic. So
=a1+0 should do the trick. -- Regards, Fred "Eric" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change text into number?
=--(A1) or =VALUE(A1)
-- David Biddulph "Eric" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change text into number?
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change text into number?
Or if the value is inside quotes then:
=MID(A1,2,LEN(A1)-2)*1 Just offering another possibility for consideration... =--SUBSTITUTE(A1,"""","") Rick |
| 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) | |||
| Change number format from text to number? | New Users to Excel | |||
| Change Text to a number | Excel Worksheet Functions | |||
| 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 | |||
Linear Mode
