Bought Pro? Your keys are in your account. Sign in

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.

Before As copied from the web page
BuchungstagVerwendungszweckBetragSaldo
03.09.2026REWE SAGT DANKE 4711-54,23 €2.145,77 €
05.09.2026Gehalt September3.250,00 €5.395,77 €
08.09.2026Miete Oktober−1.180,00 €4.215,77 €
12.09.2026Spotify AB-10,99 €4.204,78 €
20.09.2026DB Fernverkehr-89,90 €4.114,88 €
After Cleaned by StatementTidy
BuchungstagVerwendungszweckBetragBetrag currencySaldoSaldo currency
2026-09-03REWE SAGT DANKE 4711-54.23EUR2145.77EUR
2026-09-05Gehalt September3250.00EUR5395.77EUR
2026-09-08Miete Oktober-1180.00EUR4215.77EUR
2026-09-12Spotify AB-10.99EUR4204.78EUR
2026-09-20DB Fernverkehr-89.90EUR4114.88EUR
  • 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

  1. Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
  2. Open the statement. Any European bank or broker page using a decimal comma.
  3. Click the StatementTidy icon. The “Decimal comma detected” chip confirms it. You can force 1.234,56 or 1,234.56 in the popup.
  4. 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.