numbers in a cell show spaces, but spaces are not recognized and unable to format to a number

Copper Contributor

I have exported a report from Quickbooks pro (desktop version) but all the numbers that have more than 3 digits (thousands) a space is displayed.  These digits are unable to be formatted to numbers, I am unable to "Replace the space with nothing".  These values can not be used in a formula.   I have attached an example below

Please help!  I am using Quickbooks in South Africa. 

 

memicrosofthelp_0-1628785286581.png

 

1 Reply