Parse Localized Number

The Parse Localized Number module turns localized number text like 1.234,56 EUR, $1,234.56 or (500) into a real number you can calculate with in Make.com.

How it works

Numbers arriving from European shops, US invoices, Swiss bank exports or copy-pasted spreadsheets come in wildly different formats. Make's math functions expect a plain number, so "1.234,56 EUR" either throws an error or silently produces the wrong value.

This module strips currency symbols and spaces, detects the number format, resolves thousand and decimal separators, and returns a clean numeric value plus useful metadata.

Module Fields

Field	Description	How to use it
Connection	Links the module to the CustomJS service	Select or create a connection using your API key
Value	The number as text	Map any text value. Currency symbols (`€`, `$`, `EUR`, `USD`, ...) and spaces are ignored automatically
Number format	How separators are interpreted	Select, default Auto-detect. Options: Auto-detect, European (1.234,56), US-UK (1,234.56). Auto-detect decides by the last separator in the value. Ambiguous values like `1.234` are treated as thousand grouping and become `1234`; pick a fixed format to override that

Usage example

Input (Value): 1.234,56 EUR, Number format: Auto-detect

Output:

{
  "number": 1234.56,
  "rounded": 1234.56,
  "isNegative": false,
  "detectedFormat": "European",
  "originalText": "1.234,56 EUR"
}

Input (Value): (500)

Output: number: -500, isNegative: true. Accounting-style brackets are recognized as negative values.

Output

Output	Description
Number	The parsed numeric value
Rounded	The value rounded to 2 decimal places, handy for currency
Is Negative	Boolean, `true` for values like `(500)` or `-500`
Detected Format	Which format was applied (European or US-UK)
Original Text	The unchanged input, useful for logging and debugging

Good to know

Swiss apostrophes work. 1'234.50 parses to 1234.5.
Negative brackets work. Accounting notation (500) becomes -500.
Non-breaking spaces are handled, which matters for values copied from web pages or PDFs, e.g. 1 234,56.
When in doubt, fix the format. If your source is always European or always US-UK, select that format explicitly instead of Auto-detect so ambiguous values like 1.234 cannot be misread.