VBA - Macro changing number

[rafapmotta]

Hi guys,

I did a macro to clear the hidden spaces in blank lines, but as you can see in the spreadsheet attached, it's changing the number from 14,225 to 14225 and it was not supposed to happen.

Does any of you knows how to fix it?

Thanks

[Mumps1]

The numbers in your sheet all have a decimal point in them. I don't see any number with a comma. Also, your macro:

Please Login or Register  to view this content.

just trims all the cells in I2:N* of the extra spaces. When I clicked the button the numbers didn't change. By the way, this line:

Please Login or Register  to view this content.

can be written:

Please Login or Register  to view this content.