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.