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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Numbers stored as Text to Numbers 2
Convert numbers stored as text to numbers 5
Numbers stored as text 4
Access Tidy up phone numbers 0
Time Stored as Text 3
Changing Text To Numbers ? 1
Only extract numbers from a string of text 4
Convert Numbers to Text 4

Top