Separate a supported currency mark from an amount

What the normalizer removes, and what it does not

Invoices and statements often print the currency next to each amount: EUR 1.234,50, $480.00, 1.234,50 EUR. Before such a column can be added up, the label has to go. The normalizer removes one recognized label at the start of the value, such as EUR, USD, GBP, CHF, TRY, JPY or symbols like $, €, £ and ¥, and a recognized currency code such as EUR or USD at the end.

Removing the label is all it does. It does not convert between currencies, look up a rate, or check that every row in the column uses the same currency. After normalization, 1234.50 euro and 1234.50 dollars look identical.

Normalizing EUR 1.234,50

The page example uses Decimal separator , and Grouping separator . because the amount is written in the continental style. The source value EUR 1.234,50 becomes 1234.50: the label and the thousands point are removed, the comma becomes the decimal point and both fraction digits are kept.

A symbol written after the number, as in 1.234,50 €, is not in the supported list. That value is held for review and the cell keeps its original text. Move the symbol to the front or into a separate column in your copy, then calculate again.

Keeping the currency information

• Before converting, check whether the column mixes currencies. If it does, split it by currency first.
• Record the currency in a header such as Amount EUR or in its own column, since the label is gone from the output cells.
• Choose the decimal and grouping separators to match how the amounts are written, not where the currency comes from.
• Add or compare values only when they share the same currency and the same period.
• A label inside parentheses is handled too: (EUR 1.234,50) is read as negative first, the label is removed, and the result is -1234.50.
• Labels are matched in upper or lower case, so eur 1.234,50 converts as well.

Currency marks in photographed documents

The Tablora app also removes currency marks from cells when it writes an XLSX, for columns it treats as numbers, so the exported cell holds a plain number. The currency survives only in your column header or elsewhere on the page. If a column mixes currencies, split or label it in the app before export.

Small currency signs are easy to misread in a photo. If an amount cell is marked in amber, check it against the source before you rely on the value.

Original synthetic example

Source value

EUR 1.234,50

Decimal separator

,

Grouping separator

.

Expected outcome

Normalized amount: 1234.50

Tools

• numeric-normalizer