The Thousand Separator

[Smokey_Rasta_SA]

Morning All,

I am new to the forum and an Excel Newbie,

I trust everyone is well

I am having issues with finding the option to default the "Thousand Separator" on my 2011 Office Suit running on a MacOS.

I enter the , value manually but this needs to be defaulted so every time I pull a data set from scratch the comma thousand separator is set by default.

Screen Shot 2016-06-28 at 9.16.36 AM.png

The Period is set by default at the moment and I have to manually enter the Comma value.

I appreciate the assistance

[Special-K]

Does this work? This is Excel 2013 on Windows

File/Options/Advanced
Bottom of page
Use system separatiors
Untick and enter the value for the thousand separator below.