This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hey there,
I just installed Office 2016 Mac and wanted to use Excel for crunching some report data from my Shop system.
Though, I am facing a big issue: the Shop system provides the data in US local number format:
But my Mac is in German with German locales having
In Office for Win you could easily change this locale but here I couldn't find a way to adapt Excel to my needs!
Any suggestions are highly welcome!
Thanks!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
that's only part of the solution Phil. Excel willnot do anything if it is open. the international preferences are only processed as Excel initializes. So yo must first quit excel, make any changes to the system prefs, and then reopen Excel.
At this point a window will pop up that will allow you to specify:
Decimal Point, Thousand separator, type Currency and even Language.
This can be set independent of actual Language and region your in.
Be sure to set at both places.
Then you can go into Excel and Set up currency the way the should be set for your reports.
_________
Disclaimer:
The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.
Close excel. Then go to system preferences and change the nationality or number and decimal separator settings. Then restart excel and it should be ok. You may hAve to change the settings back to get the data to display the way you want.