SOLVED

Excel number formatting for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2268635%22%20slang%3D%22en-US%22%3EExcel%20number%20formatting%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2268635%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EWhen%20setting%20the%20cell%20to%20add%20space%20for%20thousand%3A%201%20000%2C%20it%20draws%20a%20square%20between%20the%201%20and%20000%20instendig%20of%20an%20empty%20space.%3C%2FP%3E%3CP%3EUseMacBook%20Pro%20late%202013%2C%20Catalina%2010.15%20and%20Excel%20for%20Mac%2016.6%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20how%20to%20get%20the%20correct%20space%20formatting%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3ERgds%20Johan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2268635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello

When setting the cell to add space for thousand: 1 000, it draws a square between the 1 and 000 instendig of an empty space.

UseMacBook Pro late 2013, Catalina 10.15 and Excel for Mac 16.6

I would be happy to know how to get the correct space formatting

Rgds Johan

2 Replies

@JohanSW On a Mac myself. Can't replicate your problem, but when you want a space as the 'thousands-separator', click the Apple logo (top left), System preferences. Then navigate to "Language and Region", "Advanced" and replace whatever grouping separators you have there now, with a space. 

Screenshot 2021-04-13 at 10.05.25.png

Now, save your work, and restart Excel.

best response confirmed by JohanSW (New Contributor)
Solution
Just fantastic!!
I have tried and searched and wondered for so long, but was never even close.
Thank you for your help and wonderfully detailed instructions