importing numbers into .csv file

[Gary Breakfield]

In Excel 2003, when saving data from web-based accounting system into .csv,
numbers stayed numbers.

In 2007, anything over 999 has a space between hundreds, thousands, and
millions and is treated as text instead oas a number. Can anyone help me
adjust the data to remove the one space and keep all data elements as numbers?

I have tried SUBSTITUTE, CLEAN, and TRIM, but none will get rid of the spaces.

Thanks.

 

[Fred Smith]

Try =--substitute(a1," ","")

The -- forces Excel to convert the text to a number.

Regards,
Fred