Converting XML report of excel output format text columns into numbers

Cause: Space at the end of the number fields.
Action:
Exporting data of number format as text, and spaces are suffixed, to remove it.

=LEFT(A1,LEN(A1)-1)
COPY THE VALUE IN TO THE OTHER COLUMN AS VALUES
THEN IT WIL POPUP TO CONVERT AS NUMBER, CLICK IT.

ITS DONE.