| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert numbers stored as text with spaces to numbers
I imported data into excel but the format for the numbers is in the form of
text with spaces eg 1000000 entered as 1 000 000, 00. execl cannot read the numbers and I would like to convert. |
|
#2
|
|||
|
|||
|
Hi!
Use a helper cell: A1 = 1 000 000, 00 B1 = Formula: =--SUBSTITUTE(SUBSTITUTE(A1," ",""),",",".") Removes the spaces and converts the comma to a decimal point. Biff "Baffuor" wrote in message ... I imported data into excel but the format for the numbers is in the form of text with spaces eg 1000000 entered as 1 000 000, 00. execl cannot read the numbers and I would like to convert. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
| How to convert Numbers to text | Excel Worksheet Functions | |||
Linear Mode
