To show numbers in the German convention in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Number or Custom, and use a format such as #.##0,00: the result displays a dot for thousands and a comma for decimals. For euros, choose a German currency format or use #.##0,00 €; formatting changes how a value looks, not the underlying number.
What German number formatting means
In the usual German-language convention, a comma marks the decimal part and a period groups thousands. The value one thousand two hundred thirty-four and a half is therefore written as 1.234,5, rather than 1,234.5. Excel can display the same numeric value according to either convention, depending on the workbook’s number format and regional settings.
This is a display convention, not a different kind of arithmetic. If a cell contains the numeric value 1234.5, Excel can still add, sort, chart, or use it in formulas when it is displayed as 1.234,50. Applying a number format does not convert the stored value or round it permanently. It controls what appears in the cell, while the formula bar can show the underlying value.
German formatting also affects dates and currency displays. A common date presentation is day, month, year, such as 03.11.2026. In Germany, a euro amount is commonly written with the symbol after the number, as in 1.234,50 €. These are useful defaults, but local practice and the workbook’s purpose can call for a different layout.
Apply a German number format in Excel
For a quick change in the Windows desktop app, select the relevant cells and open Format Cells with Ctrl+1. On the Number tab, choose Number, set the decimal places and thousands separator options, and confirm. The appearance follows the locale available to Excel; check a sample cell before applying the format to a large range.
- Select the cells, column, or range you want to format.
- Press Ctrl+1 to open the Format Cells dialog.
- Choose Number to set decimal places and digit grouping, or choose Currency or Accounting for money.
- Select an appropriate locale or German-style option if the dialog offers one, then review the sample preview.
- Click OK and check that the values still behave as numbers in calculations.
For more control, select Custom in the Category list and enter a format code in the Type box. A common German-style code for two decimal places is #.##0,00. The first part groups digits and the second part fixes two decimal places. A value of 1234.5 displays as 1.234,50, while 7 displays as 7,00.
On a Mac, select the cells and press Command+1 to open Format Cells; choose Number or Custom as needed. Some dialog labels and locale choices vary by Excel version and macOS settings, but the principle is the same. In Excel for the web, use the Home tab’s number-format controls for common formats. For complex custom formats or separator settings, the Windows or Mac desktop app offers more complete controls.
Useful German-style format codes
Custom formats let you decide whether to show grouping, decimal places, a currency mark, or negative numbers in a particular way. Enter the code in Format Cells > Number > Custom. The code examples below assume an Excel installation that accepts German-style punctuation in custom formats; if the preview does not match, use a built-in German locale format or adjust the code to match your Excel settings.
#.##0displays a whole number with digit grouping, such as12.345.#.##0,00displays exactly two decimal places, such as12.345,60.#.##0,##allows up to two decimal places without forcing trailing zeros; a whole number can display without decimal digits.#.##0,00 €places a euro symbol after the amount, for example1.234,50 €.0,0%displays a percentage with one decimal place. A stored value of 0.125 displays as12,5%.dd.mm.yyyydisplays a date with a two-digit day and month and a four-digit year, such as03.11.2026.
Excel custom formats can also have separate sections for positive numbers, negative numbers, zero, and text, separated by semicolons. For example, a two-section format can show positive values normally and negative values in red with a minus sign: #.##0,00;[Rot]-#.##0,00. Color names and punctuation can be locale-sensitive, so confirm the preview in your copy of Excel. Custom formatting is for presentation; it does not make a negative amount positive or change a calculation.
Decimal and thousands separators are a separate setting
A frequent source of confusion is the difference between a cell’s number format and Excel’s separators for entering and displaying numbers. The format controls the cell’s appearance. The separator setting determines which characters Excel treats as decimal and thousands separators in many contexts. On Windows, open File > Options > Advanced, find Editing options, and inspect Use system separators. When that option is selected, Excel uses the separators supplied by Windows regional settings. Clear it to enter your own decimal and thousands characters.
Changing separators can affect how you type values and interpret imported data, so do not switch them just to make one column look German. If the workbook is shared with other people, their system or Excel settings may differ. A more predictable approach is to keep the underlying numbers valid and apply the required number format to the cells. When a workbook must be opened in different locales, test it on the intended Excel versions and check important exports or printed reports.
Also distinguish display punctuation from formula syntax. In many German Excel installations, formulas use a semicolon between function arguments, while English-language examples often show commas. That does not mean the number’s decimal mark has changed its stored value. If you copy a formula from a website, Excel may translate separators or function names according to the installation. This article’s examples are number-format codes, not formulas.
Importing German-formatted numbers from CSV files
Formatting cannot repair text that Excel has imported as text. For example, if a CSV file contains 1.234,50 but Excel interprets it using a locale that expects a decimal point, the cell may remain text or be parsed incorrectly. A number format applied to text will not turn it into a numeric value; sums may ignore it, and numeric sorting may put it in an unexpected order.
For a CSV import in Excel for Microsoft 365 on Windows, use Data > From Text/CSV and check the preview before loading. If necessary, choose Transform Data. In Power Query, select the affected column and use Transform > Data Type > Using Locale, then choose the appropriate data type and German locale. This tells the import process how to interpret decimal and grouping marks instead of merely changing the displayed style.
For a small one-off dataset, Text to Columns can sometimes help convert text values, but first confirm the separators and preview the result. Do not use a global find-and-replace blindly: replacing every period with a comma, for example, can damage dates, text, or values where the period has a different role. Keep an untouched copy of the source file if the data is important, and check several converted values against the original.
Choosing currency, dates, and percentages
Use a built-in format when it meets the reporting need. Number is suitable for quantities and measurements; Currency or Accounting is usually clearer for monetary amounts; Percentage is designed for ratios; and Date gives calendar values a readable date presentation. These choices also make it easier for another person to understand the intent of a column than a collection of unexplained custom formats.
Currency symbols are not proof of the currency stored in a value. Excel’s Currency format displays a symbol, but a cell containing 100 does not itself say whether it means 100 euros, dollars, or another unit. Use a clearly labelled column heading, and select the correct symbol and locale for the report. Accounting format aligns currency symbols and decimal places across a column, which can make financial tables easier to scan.
Dates need particular care because a date is stored as a serial value in Excel, and different locales may interpret an entry such as 04/05/2026 as April 5 or May 4. Formatting an already recognized date as dd.mm.yyyy changes its display, not the date Excel stored. For imported or ambiguous dates, specify the locale during import and verify a few records before relying on them.
Common problems and how to diagnose them
- The decimal comma does not appear: Check the selected cells’ number format and the system-separator setting. A custom format may be using punctuation appropriate to a different locale.
- The value is left-aligned or will not sum: It may be text rather than a number. Check the formula bar and import method; applying a number format alone will not convert text.
- Zeros or decimals look different than expected: The format may force or suppress decimal places. For example,
#.##0,00always shows two places, while optional decimal placeholders can omit trailing zeros. - A date changes to an unexpected day or month: The source was probably interpreted using a different date order. Correct the import interpretation, not just the display format.
- The format works on one computer but not another: Regional settings, Excel versions, or how the custom code is interpreted can vary. Use built-in locale formats where possible and test shared workbooks.
One useful check is to select a questionable cell and try a basic calculation such as adding it to a known number in a separate test cell. If Excel treats it as text, the result may not behave as expected. Undo the test or remove the temporary cell afterward. For a large import, verify totals and sample records rather than assuming that a plausible-looking display proves correct conversion.
Frequently Asked Questions
How do I change Excel to German number format?
Select the cells, press Ctrl+1 on Windows (Command+1 on Mac), then choose a German-style Number or Custom format. Use #.##0,00 for two decimal places and grouped thousands.
How do I show euros after the number?
Choose a euro Currency format with the symbol after the amount, if available, or apply a suitable custom format such as #.##0,00 €. Check the preview because accepted punctuation can depend on regional settings.
Why is my German number stored as text in Excel?
Excel may have read the source using different decimal and thousands separators. Import the data using the correct locale, or convert the text carefully; changing the cell’s display format by itself does not convert it to a number.
Does changing the number format change the value?
No. A number format changes how a valid numeric value is displayed. It does not change the stored value, though rounding in the display can hide digits that remain in the cell.
How do I type a decimal comma in Excel?
With system separators enabled, Excel normally follows the decimal separator in the operating system’s regional settings. On Windows, review File > Options > Advanced > Use system separators if Excel is using an unexpected character.
Choose formatting based on the workbook’s audience
For a workbook used only in a German regional setting, a built-in German number, date, or currency format is usually the simplest choice. For shared workbooks, imported datasets, or reports that must retain consistent presentation across computers, separate the issues: make sure values are genuinely numeric, apply an explicit cell format, and test the result in the environments that matter. This avoids the most common misconception—that changing a number’s appearance also changes how Excel understands its value.
Related
- Excel Data Validation List: Can You Select Multiple?
- Excel Data Validation List: Remove Duplicates
- Excel Number Format: How Many Digits Can It Really Show?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- PowerPoint Audio Controls: Add and Customize PlaybackTo add audio controls to a PowerPoint slide, insert an audio file with Insert > Audio, select the…
- Word Mail Merge: Remove Decimal Places from Number FieldsTo remove decimal places from a Word mail merge result, edit the merge field and add the number-format…
- Excel Text to Value: Convert Numbers Stored as TextTo turn numeric text into a real Excel number, select the cells and choose Convert to Number from…
- Translate Google Sheets to English: Formulas, Steps and TipsTo translate text in Google Sheets into English, enter a formula such as =GOOGLETRANSLATE(A2,"auto","en") in an empty cell,…
- Excel Goal Seek for Multiple Cells: How Solver WorksExcel’s Goal Seek can change only one input cell at a time. To make Excel adjust multiple cells…
- Hide a Column in a Power BI Table: Options ExplainedYes, but the right method depends on what you mean by “hide.” To remove a column from one…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.