Yes. To convert German-formatted text such as 1.234,56 into a real Excel number, put the text in A2 and enter =NUMBERVALUE(A2,",",".") in another cell; it returns the numeric value 1234.56. For a one-time conversion, Excel’s Text to Columns tool can also interpret a comma as the decimal separator and a period as the thousands separator.
What “German number format” means in Excel
German-style numbers commonly use a period to group thousands and a comma for the decimal mark: 1.234,56 means one thousand two hundred thirty-four and 56 hundredths. The English-style format many readers mean is the US convention, 1,234.56. English-speaking regions do not all use identical conventions, so this article uses US-style punctuation as the target.
The punctuation you see does not by itself tell you whether Excel has stored a number or text. If Excel recognizes an entry as numeric, its underlying value is independent of how it is displayed. A value of 1234.56 can be shown with German or US-style separators by changing the number display settings. But if Excel has stored 1.234,56 as text, changing its display format will not convert it: first parse the text into a number.
This distinction matters for sorting, totals, charts, and calculations. Text that looks like a number may sort alphabetically and may be ignored by a sum. A quick clue is alignment: numbers are usually right-aligned by default and text is usually left-aligned, but alignment can be changed, so it is not a conclusive test.
Convert a text value with NUMBERVALUE
For a German-formatted text value in A2, enter this formula in B2:
=NUMBERVALUE(A2,",",".")
The second argument tells Excel that the decimal separator in the source text is a comma; the third says its group separator is a period. With A2 containing the text 1.234,56, the result is the numeric value 1234.56. Fill the formula down to convert the rest of a column. NUMBERVALUE is available in current Excel versions, including Microsoft 365.
The formula produces a number, not a permanent punctuation style. Excel may display the result using the separators set for your Excel installation. If it appears as 1.234,56 after conversion, that does not mean the conversion failed: check that the result cell contains a number, then adjust its display settings as described below.
If the text includes a known currency symbol, remove it as part of the conversion. With the source text in A2 and a euro symbol included, use:
=NUMBERVALUE(SUBSTITUTE(A2,"€",""),",",".")
For example, the text 1.234,56 € converts to 1234.56. This example removes only the euro character; other symbols, labels, or unusual spacing may need their own cleanup. Keep the original column until you have checked the converted results.
Use Text to Columns for a one-time conversion
Text to Columns is useful when a whole selected column contains text values in one consistent format and you do not want to keep a formula column. In Excel for Microsoft 365 on Windows:
- Select the cells containing the German-formatted text. Leave room in the columns to the right if the selection might be split.
- Choose Data > Text to Columns.
- Choose Delimited, then select Next twice to reach the final step.
- Select Advanced. Set the decimal separator to a comma and the thousands separator to a period, then confirm.
- Select Finish and inspect several results, including values with and without decimal digits.
The tool parses the selected text using the separators you specified. It does not merely replace punctuation, which is important: replacing every period with nothing and every comma with a period can damage values that contain unexpected characters or inconsistent formatting. Text to Columns may write results into adjacent cells if it detects multiple fields, so check the preview and keep a backup when the data is important.
On Excel for Mac, the Text to Columns command is also on the Data tab, though the dialog layout can differ by release. Look for the option to set decimal and thousands separators in the conversion dialog. If that option is not available in your build, use NUMBERVALUE with explicit separators or import the file through Power Query.
Import a German CSV with the right locale
A CSV file contains text values separated by a delimiter; it does not reliably carry Excel number formats. If you open a German CSV directly, Excel may interpret its contents using your computer’s current regional settings. This can cause values to arrive as text or be read incorrectly, especially when the file uses commas both as decimal marks and as field delimiters.
For a repeatable import in Excel for Microsoft 365 on Windows, use Data > From Text/CSV, choose the file, and select Transform Data if you need to control how a column is interpreted. In the Power Query Editor, select the relevant column, then use Transform > Data Type > Using Locale. Choose Decimal Number as the data type and the source locale, such as German (Germany), so the comma and period are read according to the file’s conventions. Confirm the change, then choose Home > Close & Load.
Power Query converts the column into numeric values; it does not force a particular on-screen punctuation style. After loading, Excel’s number display settings still determine whether you see German or US-style separators. This method is especially helpful when you will refresh the same import regularly, because you can preserve the parsing step rather than repeat a manual conversion. If you use Excel for Mac or Excel for the web, available import options may vary by version; the desktop Windows steps above describe Microsoft 365 for Windows.
Change how numbers are displayed
If cells already contain correct numeric values and only look German, do not convert them again. You can change Excel’s separators for the application: choose File > Options > Advanced, find Editing options, clear Use system separators, and enter a period for the decimal separator and a comma for the thousands separator. This changes how Excel displays and accepts numeric separators across the application, so it can affect other workbooks and data entry. Select Use system separators again to return to the Windows regional defaults.
For cell-level number styling, select the cells and press Ctrl+1 to open Format Cells. On the Number tab, choose Number, set the decimal places, and choose whether to use a thousands separator. The actual characters shown can still depend on Excel’s separator settings. On Mac, use Command+1 to open Format Cells; the dialog may be arranged differently. In Excel for the web, number-format controls are available on the Home tab, but the desktop Options path for overriding separators is not the same.
These are separate operations: conversion changes text into a numeric value, while formatting changes how a numeric value is presented. If a workbook is shared with people using different regional settings, they may see different separator characters even though the stored value is the same. For consistent data exchange, provide a clear export convention or use a controlled CSV import rather than relying on how the cells happen to look on one computer.
Common problems and checks
- The result still looks German. Check whether the output is a real number before changing the formula. The cell may have converted correctly while Excel continues to display local separators.
- The formula returns an error. Confirm that the source text actually uses comma decimals and period grouping, and that the arguments match that pattern. A value such as
1,234.56needs the opposite separator arguments. - Some rows convert and others do not. Look for currency labels, extra punctuation, blanks, or inconsistent source conventions. Do not assume every row in a mixed dataset follows the same pattern.
- Leading zeros disappear. That is expected when a text identifier is converted to a number. Postal codes, account codes, and product IDs are often identifiers rather than quantities; keep them as text if the zeros are meaningful.
- Dates or percentages change unexpectedly. They are not ordinary decimal quantities. Treat dates and percentages according to their own conventions, and verify the result before applying a number format.
- Values look rounded. A cell format can hide decimal places without changing the underlying value. Increase the displayed decimal places or inspect the value in the formula bar before concluding that digits were lost.
Which conversion method should you choose?
Choose based on what the cells contain and whether you need to repeat the task:
- Use NUMBERVALUE when the cells are text, you want explicit control over source separators, or you need a formula you can fill down and audit.
- Use Text to Columns for a quick, one-time conversion of a consistent column when you are comfortable replacing or writing beside the source data.
- Use Power Query with Using Locale for recurring CSV imports or larger datasets where the same interpretation should be applied each refresh.
- Change Excel’s separators or number format when the values are already numeric and the problem is only how they appear.
Before replacing source data, check a small sample: a value with a thousands group, one with decimal digits, an integer, and any unusual entries such as currency amounts. Confirm that the converted values behave like numbers in a calculation and that the displayed result matches the intended convention.
Frequently Asked Questions
How do I change 1.234,56 to 1,234.56 in Excel?
First ensure the source is a number rather than text. For text in A2, use =NUMBERVALUE(A2,",","."); it returns 1234.56. Then set Excel’s separators or number display to show US-style punctuation.
Does changing the number format convert text to numbers?
No. Number formatting changes the appearance of numeric values; it does not parse text. Use NUMBERVALUE, Text to Columns, or a locale-aware import to convert text first.
Will changing separators affect every workbook?
Excel’s Use system separators setting is an application-level option, not a conversion limited to the selected cells. It can affect other workbooks and numeric entry in Excel, so restore system separators if you do not want that behavior.
Why does Excel show a period or comma differently on another computer?
Excel can display the same stored number according to different regional or separator settings. The underlying numeric value may be unchanged; compare the value and formatting settings rather than relying only on punctuation.
Can I convert a German CSV without opening and re-saving it first?
Yes. Import it through Data > From Text/CSV, then use Power Query’s Data Type > Using Locale option to parse the source column with German conventions before loading it into the worksheet.
Related
- What Column Number Is V in Excel? Find It in Seconds
- How to Combine Two Cells in Excel and Keep Both Values
- Column J Number in Excel: How to Find and Use It Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Find a Table in Excel: Search and NavigationTo find a table in Excel, search for a word or value you expect it to contain, then…
- How to Create Multiple Labels in Word, Step by StepTo create multiple labels in Microsoft Word, choose a label size, then either fill a sheet with the…
- Excel Circular Reference Greyed Out? Find the CauseIn Excel for Microsoft 365 on Windows, the Circular References command is usually greyed out because Excel has…
- Compare Two Columns in Excel Without Matching RowsTo compare two columns as unordered lists—not by checking cells on the same row—test whether each value in…
- How to Hide Columns in Excel: A Step-by-Step GuideTo hide columns in Excel for Microsoft 365 on Windows, select one or more column headers, right-click the…
- Google Sheets vs Excel: How Similar Are They?Google Sheets and Microsoft Excel are highly similar for everyday spreadsheet work: both organize information in cells, calculate…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.