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

%3CLINGO-SUB%20id%3D%22lingo-sub-2641736%22%20slang%3D%22en-US%22%3Enumbers%20in%20a%20cell%20show%20spaces%2C%20but%20spaces%20are%20not%20recognized%20and%20unable%20to%20format%20to%20a%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2641736%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20exported%20a%20report%20from%20Quickbooks%20pro%20(desktop%20version)%20but%20all%20the%20numbers%20that%20have%20more%20than%203%20digits%20(thousands)%20a%20space%20is%20displayed.%26nbsp%3B%20These%20digits%20are%20unable%20to%20be%20formatted%20to%20numbers%2C%20I%20am%20unable%20to%20%22Replace%20the%20space%20with%20nothing%22.%26nbsp%3B%20These%20values%20can%20not%20be%20used%20in%20a%20formula.%26nbsp%3B%26nbsp%3B%26nbsp%3BI%20have%20attached%20an%20example%20below%3C%2FP%3E%3CP%3EPlease%20help!%26nbsp%3B%20I%20am%20using%20Quickbooks%20in%20South%20Africa.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22memicrosofthelp_0-1628785286581.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302766iBD300AAC886469A8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22memicrosofthelp_0-1628785286581.png%22%20alt%3D%22memicrosofthelp_0-1628785286581.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2641736%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2654794%22%20slang%3D%22en-US%22%3ERe%3A%20numbers%20in%20a%20cell%20show%20spaces%2C%20but%20spaces%20are%20not%20recognized%20and%20unable%20to%20format%20to%20a%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654794%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20able%20to%20assist%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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