Forum Discussion
Solved
German Numer Format for Euro
Hi there, I have an ongoing problem or better challenge in Excel. Whenever I use the Euro format the numbers formatted look like the following: 1,234.00 €. In the German accounting world they should look like 1.234,00 €. The Mac I use I purchsed in Hong Kong a couple of years ago. Keybord is English. However, my Office 365 account is set to Germany. Anybody with a useful idea? Cheers
- HI,
Select the cell or range of cells that you want to format.
Right-click and select "Format Cells" from the context menu.
In the Format Cells dialog box, select the "Number" tab.
Under "Category," select "Custom."
In the "Type" field, enter the following format code: #.##0,00 €
Click "OK" to apply the format to the selected cells.
This should format the numbers in the German accounting style with a comma as the thousands separator and a period as the decimal separator. If you find that this format is not sticking or reverts back to the Euro format, you may need to change the language settings on your computer to German, as this may be overriding your Office 365 settings.
To change your language settings in Windows:
Go to "Settings" > "Time & Language" > "Language."
Click "Add a language" and select "German."
Move "German" to the top of the list of preferred languages.
Restart Excel and try formatting the cells again.
I hope this helps!
- HI,
Select the cell or range of cells that you want to format.
Right-click and select "Format Cells" from the context menu.
In the Format Cells dialog box, select the "Number" tab.
Under "Category," select "Custom."
In the "Type" field, enter the following format code: #.##0,00 €
Click "OK" to apply the format to the selected cells.
This should format the numbers in the German accounting style with a comma as the thousands separator and a period as the decimal separator. If you find that this format is not sticking or reverts back to the Euro format, you may need to change the language settings on your computer to German, as this may be overriding your Office 365 settings.
To change your language settings in Windows:
Go to "Settings" > "Time & Language" > "Language."
Click "Add a language" and select "German."
Move "German" to the top of the list of preferred languages.
Restart Excel and try formatting the cells again.
I hope this helps!It worked. Cheers
