Number format: OSX versus Excel

allanb · 01-18-2013, 03:18 AM

I need to have numbers displayed with a period as the thousands separator and a comma as the decimal separator. I'd like to have this as a default, so that I don't have to build a custom number format for every permutation of currency symbol, number of decimal places, and positive/negative display.

As far as I can see, Excel (from Office:Mac 2008) doesn't give me any control over the separators – it uses the US/UK convention, which of course is the other way round.

The settings in Mac's System Preferences apparently don't have any effect on Excel.

Is there a way?

NaOH · 01-18-2013, 03:23 AM

Just in case you didn't follow this procedure: If you make the change in System Preferences, you'll need to quit and relaunch Excel for the new format to appear there.

allanb · 01-19-2013, 02:10 AM

That was my mistake. Fixed now. Many thanks.

01-18-2013, 03:18 AM	#1
allanb Triple-A Player Join Date: Nov 2006 Location: Aquitaine, France Posts: 176	Number format: OSX versus Excel I need to have numbers displayed with a period as the thousands separator and a comma as the decimal separator. I'd like to have this as a default, so that I don't have to build a custom number format for every permutation of currency symbol, number of decimal places, and positive/negative display. As far as I can see, Excel (from Office:Mac 2008) doesn't give me any control over the separators – it uses the US/UK convention, which of course is the other way round. The settings in Mac's System Preferences apparently don't have any effect on Excel. Is there a way?

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

01-18-2013, 03:23 AM	#2
NaOH Hall of Famer Join Date: Dec 2007 Posts: 3,642	Just in case you didn't follow this procedure: If you make the change in System Preferences, you'll need to quit and relaunch Excel for the new format to appear there.

01-19-2013, 02:10 AM	#3
allanb Triple-A Player Join Date: Nov 2006 Location: Aquitaine, France Posts: 176	That was my mistake. Fixed now. Many thanks.