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.

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.