Make.com LabAdvanced
Format Numbers with Thousands Separators in Make.com
An invoice template needs the amount shown as 1,234.50 (US format). Make's defaults use European separators.
Live Execution Simulator
Idle
📥
Incoming Data
⚙️
Make.com Node
🎯
Next Step
> Ready. Type your expression below and click "Check Answer" to run the node.
Incoming Payload / Data:
{
"amount": 1234.5
}
Press Enter or click Check Answer. +30 XP
✅ Solution & explanation
formatNumber(amount; 2; .; ,)
Output: 1,234.50
formatNumber() defaults to a comma as the decimal separator and a period for thousands (1.234,50). Passing . and , as the 3rd and 4th arguments switches to US formatting.💡 Pro tip: The result is text, not a number — format only at the last step, right before displaying it.
Also accepted: formatNumber(amount; 2; "."; ",")