How do I convert numbers stored as text with spaces to numbers

B

Baffuor

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.
 
B

Biff

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
 
Top