Number failing ISNUMBER validation

I have a column of numbers that are failing the ISNUMBER validation because, when copied from a different report, there are three spaces including to the right of the number. So ISNUMBER is returning false until I remove those three spaces. Is there a macro I can build to format these cells correctly, ie remove the extra spaces?

I've tried using TRIM to no avail...

NOTE: Sometime is I simply click on the cell and hit enter the validation will go from FALSE to TRUE. I know this has something to do with the import of data, but I can't fix each cell like this, it'll take me hours everyday. I need a way to automate the process.