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.