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