Guide · StatementTidy
How to convert European numbers (1.234,56) in Excel
Short answer
Use =NUMBERVALUE(A2, ",", ".") (Excel 2013 and later), after removing the € sign and replacing a Unicode minus. Or Text to Columns → Advanced and set the decimal separator to a comma. StatementTidy detects the decimal comma from the whole table, so 1.234,56, 1 234,56 and 1’234.56 all become real numbers, and the € moves to its own column.
Last updated · by Mumshad Jawad
Why this happens
German, French, Spanish, Italian, Dutch and many other banks write one thousand two hundred and thirty-four euros fifty-six as 1.234,56: a dot for thousands and a comma for decimals. On a computer set to English, Excel reads that as text, or worse, reads 1.234 as one point two three four.
German bank exports add two more traps: the € sign after the number (-54,23 €) and sometimes a typographic minus (−1.180,00, U+2212) that no Excel function accepts as a minus.
Real example: before and after
The rows below are fictional. The “after” table is not a mock-up: this page ran them through StatementTidy’s cleaning engine (the same clean.js the extension uses, v1.0.1) with its default options, and shows exactly what you would export.
| Buchungstag | Verwendungszweck | Betrag | Saldo |
|---|---|---|---|
| 03.09.2026 | REWE SAGT DANKE 4711 | -54,23 € | 2.145,77 € |
| 05.09.2026 | Gehalt September | 3.250,00 € | 5.395,77 € |
| 08.09.2026 | Miete Oktober | −1.180,00 € | 4.215,77 € |
| 12.09.2026 | Spotify AB | -10,99 € | 4.204,78 € |
| 20.09.2026 | DB Fernverkehr | -89,90 € | 4.114,88 € |
| Buchungstag | Verwendungszweck | Betrag | Betrag currency | Saldo | Saldo currency |
|---|---|---|---|---|---|
| 2026-09-03 | REWE SAGT DANKE 4711 | -54.23 | EUR | 2145.77 | EUR |
| 2026-09-05 | Gehalt September | 3250.00 | EUR | 5395.77 | EUR |
| 2026-09-08 | Miete Oktober | -1180.00 | EUR | 4215.77 | EUR |
| 2026-09-12 | Spotify AB | -10.99 | EUR | 4204.78 | EUR |
| 2026-09-20 | DB Fernverkehr | -89.90 | EUR | 4114.88 | EUR |
- Date column converted to ISO YYYY-MM-DD (DD/MM detected)
- Decimal comma detected (1.234,56 → 1234.56)
- 4 negative amounts as real negative numbers
- Currency moved to its own column (Betrag currency, Saldo currency)
Open this example in the live demoEdit the rows, paste your own table, toggle options. Nothing is uploaded.
How to fix it by hand in Excel
NUMBERVALUE
With the text in A2:
=NUMBERVALUE(SUBSTITUTE(SUBSTITUTE(A2,"€",""),"−","-"), ",", ".")
The second argument is the decimal separator and the third the thousands separator in the source text. Spaces are ignored.
Text to Columns
Select the column, Data → Text to Columns → Delimited → Next → Next → Advanced…, set Decimal separator to , and Thousands separator to ., then OK → Finish. Remove the € first with Ctrl+H.
Google Sheets
Set File → Settings → Locale to the bank’s country (for example Germany) before pasting.
How to fix it in one click with StatementTidy
- Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
- Open the statement. Any European bank or broker page using a decimal comma.
- Click the StatementTidy icon. The “Decimal comma detected” chip confirms it. You can force 1.234,56 or 1,234.56 in the popup.
- Copy for Excel. Numbers paste as numbers in any Excel locale; choose semicolon CSV in the options for European Excel.
Get StatementTidy free for ChromeTry it on a sample statement
Questions
How does it tell 1.234 (one thousand) from 1.234 (one point two)?
It looks at every number in the table. A value like 54,23 or 2.145,77 can only be a decimal comma, and those unambiguous values decide for the whole table. If the table gives no clue it falls back to the page language.
Does it handle Swiss and Indian formats?
Yes: 1’234.56 (Swiss apostrophe), 1 234,56 (space grouping) and 1,23,456.78 (Indian lakh grouping) are all read as numbers.
Why semicolon CSV?
Excel in comma-decimal locales uses the semicolon as its list separator, so a comma-separated file opens in one column. StatementTidy’s options offer semicolon CSV for that case.