If an expense sheet suddenly returns zeros or errors after you paste bank data, check the decimal mark and the formula separator before anything else. Many European setups use a comma for decimals and a semicolon between formula arguments, so a formula or a number copied from a different setup stops working even though it looks correct.
Why does a formula from the internet fail?
A formula written as =SUMIFS(C2:C500,B2:B500,"Food") uses commas between arguments. On a computer where the comma is the decimal mark, the same formula must be typed with semicolons: =SUMIFS(C2:C500;B2:B500;"Food"). Excel usually converts these when you type in your own setup, but pasted text or a shared workbook can arrive in the wrong style and report an error.
| Setup | Decimal mark | Argument separator | Example formula |
|---|---|---|---|
| Point-decimal | point | comma | =SUM(C2:C500) |
| Comma-decimal | comma | semicolon | =SUMIFS(C2:C500;B2:B500;"Food") |
How do you spot numbers that are really text?
Amounts like 1.250,50 pasted into a point-decimal sheet are text, and sums skip them. The check is =ISNUMBER(C2). To convert a text value on a point-decimal setup: =VALUE(SUBSTITUTE(SUBSTITUTE(C2,".",""),",",".")). That removes the thousands point first and then turns the comma into a point. On a comma-decimal setup the same cleaning is needed in reverse for files that arrive with points.
A worked example with euro figures
Say a pasted block contains €1.250,50 for rent, €86,20 for energy and €310,00 for food, but all three are text. A sum of the column returns 0. After conversion they are 1250.50, 86.20 and 310.00, and the total is 1250.50 + 86.20 + 310.00 = 1,646.70. If your report showed 0 or a figure far too low, text amounts are the first suspect.
- Test one amount with ISNUMBER.
- Decide which setup your sheet uses.
- Convert text amounts with a helper column.
- Paste the helper column back as values.
- Check the total against the bank statement.
What about shared workbooks?
- A workbook edited by someone with a different regional setup may show errors for them but not for you
- Agree a single convention for decimals and dates before sharing
- Keep amounts in one column and one currency, with the currency noted in the header
Is there a way to skip the repair?
If building reports from pasted data is a monthly chore, a tool that creates reports from stored transactions avoids it. SpendixAI is built around India and INR, so it does not serve euro accounts, but its reports are generated from the transactions rather than hand-built formulas, and that is a useful test to apply.
What if you work with someone on another setup?
Send a workbook rather than pasted text, since formulas in a saved file are stored in a neutral form and display in each person's own style. Problems usually come from copying formulas as plain text through email or chat, where the separators arrive unchanged. If you must share a formula in text, write which separator it uses. When the other person sees an error, ask whether their decimal mark is a point or a comma, because that single answer explains most cases.
How do you protect the report from future pastes?
Paste new data into a raw tab and keep the report on a separate tab that reads from the cleaned column. Add a column beside the raw amount that converts and tests it, so a bad row shows a visible flag instead of turning the total to zero. A line such as =IF(ISNUMBER(C2),C2,"CHECK") is enough to stop silent errors, and the word CHECK in a column draws your eye quickly.
Checklist
- Separator style matches your setup
- Amounts pass ISNUMBER
- Dates pass ISNUMBER
- Total tied to the statement
- One currency per column
Useful ideas start with a clearer picture of your own spending.
Explore your reports


