Problem: Code to remove Spaces re-formats numbers. Why?

[AleXSR700]

Hello everyone,

I am using the following code to remove all spaces within a worksheet.

This works for the spaces, but for some reason all my numbers in that sheet get multiplied by 1000.

I thnk this may be some kind of reformatting.

The rest of the code is the following

So I am importing a source txt file with a number 3,77E3. This is then, after copying, 3,77E3. But after running the replace-spaces-code this turns into 3,77E6.

Anybody have an idea as to why and how I can fix this?

[mjr veverka]

1. Some example of such a "txt" file would be useful (false data)
2. Perhaps, this "kind of thing" may be the result of your system settings "being in conflict" with "excel/vba settings" (made in eu vs. made in usa) ... (?)