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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top