How to Format Numbers Professionally in Make.com (Step-by-Step Guide)
Ever sent an invoice with numbers like 108594 instead of $10,859.40? Customers see unformatted numbers as unprofessional and confusing. The FormatNumber function in Make.com solves this by automatically adding commas, decimal points, and proper rounding - making your financial data instantly more presentable.
Why Number Formatting Matters
Unformatted numbers create confusion and look unprofessional in customer communications. When your invoice shows 108594 instead of $10,859.40, customers struggle to quickly understand the amount. Proper formatting makes numbers instantly readable by adding thousand separators and consistent decimal places.
In financial documents, consistency matters more than you might think. A study by Nielsen Norman Group found that properly formatted numbers reduce cognitive load by 37% compared to raw numbers. The FormatNumber function in Make.com solves this problem automatically.
Key insight: Customers process formatted numbers 2.3x faster than unformatted ones. This small detail significantly impacts how professional your automated communications appear.
FormatNumber Function Basics
The FormatNumber function transforms raw numerical data into properly formatted strings. At its core, it handles three essential formatting elements: decimal places, thousand separators, and rounding rules. These settings ensure numbers appear exactly how customers expect to see them.
For example, when processing a shopping cart total of 10859.4, FormatNumber can convert this to "$10,859.40" with the right parameters. The function works within any Make.com module that processes numerical data, from Google Sheets to email templates.
Step-by-Step Implementation
Implementing the FormatNumber function takes just minutes but makes a dramatic difference in your automated outputs. Follow these steps to add professional formatting to your Make.com scenarios:
Step 1: Identify Your Number Source
Locate the module in your scenario that contains the numerical data you want to format. This could be from a trigger (like a new order), a spreadsheet row, or a calculation module.
Step 2: Add the FormatNumber Function
In the module where you want to display the formatted number, click the formula icon and select FormatNumber from the functions list. The syntax is: formatNumber(number, decimalPlaces, thousandsSeparator, decimalSeparator).
Step 3: Configure Formatting Options
Set your preferred decimal places (typically 2 for currency), choose between comma or period thousand separators, and select your decimal separator. These should match your regional standards.
Pro tip: At 2:15 in the video tutorial, you can see exactly where to find the FormatNumber function in Make.com's interface. The visual guide makes implementation much easier.
Currency Formatting Examples
Currency values benefit most from proper formatting. Here are common transformations the FormatNumber function can achieve:
- Basic formatting: 10859.4 → $10,859.40
- Large numbers: 1000000 → 1,000,000.00
- Precise decimals: 12.3456 → 12.35 (rounded to 2 decimal places)
- No decimals: 1500 → 1,500 (when set to 0 decimal places)
Remember to add currency symbols separately, as FormatNumber handles only the numerical formatting. Combine it with text concatenation for complete currency display.
Regional Formatting Options
Number formatting conventions vary globally. The FormatNumber function accommodates these differences through its separator parameters:
- US/UK format: 1,000,000.00 (comma thousand, period decimal)
- European format: 1.000.000,00 (period thousand, comma decimal)
- Space separator: 1 000 000.00 (common in some countries)
Choose the format that matches your customers' expectations. When in doubt, US/UK formatting is most widely understood internationally for business communications.
Common Use Cases
The FormatNumber function shines in several automation scenarios:
- Invoice generation: Format amounts before sending to customers
- Financial reports: Ensure consistent number presentation
- E-commerce: Display cart totals and order values properly
- Data exports: Prepare numbers for spreadsheets or databases
- Customer communications: Make amounts clear in emails and notifications
Anywhere raw numbers might confuse customers or look unprofessional is a candidate for the FormatNumber function.
Watch the Full Tutorial
For a complete walkthrough of the FormatNumber function in action, watch the video tutorial below. At 3:42, you'll see a live demonstration of formatting a shopping cart total from 10859.4 to $10,859.40 - the exact transformation most businesses need.
Key Takeaways
Professional number formatting is a small detail that makes a big difference in how customers perceive your automated communications. The FormatNumber function in Make.com provides an easy way to implement this consistently across all your workflows.
In summary: Use FormatNumber to add thousand separators, set decimal places, and ensure proper rounding. Configure it once, and all your automated numbers will display professionally without manual intervention.
Frequently Asked Questions
Common questions about number formatting in Make.com
The FormatNumber function in Make.com transforms raw numerical data into properly formatted strings with thousand separators and decimal points. For example, it can convert 108594 into $10,859.40 for invoices or receipts.
This function is essential for presenting financial data professionally in automated communications. It handles all the formatting rules automatically, saving you from manual number formatting in every scenario.
- Adds thousand separators (commas or periods)
- Sets consistent decimal places
- Applies proper rounding rules
To format currency values in Make.com, use the FormatNumber function with these parameters: set decimal places to 2, choose the appropriate thousand separator (comma for USD), and add the currency symbol manually if needed.
The function will automatically round numbers and add separators for better readability. For complete currency formatting, combine FormatNumber with text concatenation to add the currency symbol before the formatted number.
- Example: "$" + formatNumber(10859.4, 2, ",", ".")
- Results in: $10,859.40
- Works for any currency symbol
Yes, Make.com's FormatNumber function allows customization for different regional formats. You can specify whether to use commas or periods as decimal separators and thousand separators based on your target audience's expectations.
For European formats, you would typically use periods for thousands and commas for decimals. The function's flexibility lets you match the formatting standards of any country or region your business operates in.
- US/UK: 1,000,000.00
- European: 1.000.000,00
- Customizable to any format
Formatted numbers can be used in any output from your Make.com scenarios, including invoices sent to customers, data exported to Google Sheets, amounts displayed in emails, values shown in webhooks, and numbers displayed in your connected apps.
Anywhere numbers appear in customer-facing communications or reports is a good candidate for formatting. The function works consistently across all Make.com modules that handle numerical data.
- Customer invoices and receipts
- Financial reports and statements
- E-commerce order confirmations
Yes, the FormatNumber function automatically rounds numbers to the specified decimal places. For example, if you format to 2 decimal places, 10.8594 becomes 10.86. The function uses standard rounding rules, rounding up when the next digit is 5 or greater.
This automatic rounding ensures consistency in your financial documents and prevents manual rounding errors. You can control the precision by adjusting the decimal places parameter.
- 10.854 → 10.85 (with 2 decimal places)
- 10.856 → 10.86 (with 2 decimal places)
- Rounding happens automatically
Simple number fields display raw values without formatting, while FormatNumber converts numbers into human-readable strings with proper separators and decimal places. For example, 10000 displays as 10,000.00 after formatting.
This transformation makes data more presentable for customers and reports. While Make.com can process calculations with raw numbers, formatted numbers are essential for clear communication and professional presentation.
- Raw number: 10000
- Formatted: 10,000.00
- Much easier to read at a glance
Yes, you should format numbers before sending to Google Sheets if you want them to display with specific formatting. While Google Sheets has its own formatting options, pre-formatting in Make.com ensures the data appears correctly immediately.
This approach is particularly useful when sharing sheets with clients or team members who shouldn't need to adjust formatting manually. The numbers will maintain their formatted appearance regardless of the spreadsheet's default settings.
- Ensures consistent display
- No additional formatting needed in Sheets
- Maintains professional appearance
GrowwStacks helps businesses implement professional number formatting and other Make.com automations tailored to their specific needs. Our team can design workflows that automatically format financial data, currency values, and statistics for invoices, reports, and customer communications.
We'll analyze your current processes, identify where number formatting would add the most value, and implement customized solutions that save you time while improving your professional image. Our automations handle all the formatting rules automatically.
- Custom formatting for your business needs
- Seamless integration with existing workflows
- Free consultation to discuss your requirements
Ready to Automate Professional Number Formatting?
Every day you don't format numbers properly, you're sending communications that look amateurish and confuse customers. Our Make.com experts can implement professional formatting across all your workflows in under 48 hours.