I have a problem with a report which is generated using another business reporting tool.
In the column that displays amounts, not all the numbers are treated as such. There is a space acting as a 1000 separator, and in order to have these amonts act like numbers I need to remove this space. If I try to use the Replace function and substitute space for nothing, there is no change.
Does anybody know what causes some of the numbers to be displayed correctly as numbers and other incorrectly, and hopefully how to fix this?
I'd be grateful for any and all tips!

RE