Excel number formatting for Mac

[JohanSW]

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]

@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. 

Now, save your work, and restart Excel.

[#3 · Accepted solution]

Just fantastic!! :grinning_face_with_sweat:
I have tried and searched and wondered for so long, but was never even close.
Thank you for your help and wonderfully detailed instructions :thumbs_up::ok_hand::clapping_hands: