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.

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

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

Regards,
Fred

"Gary Breakfield" .(donotspam) wrote in message
...
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.