Modify number formats in Zaps

Last updated: November 08, 2019

Formatter: Numbers

Formatter is a Zapier feature that can format information sent from any other app. Here, we'll look at how to modify and format numbers with Formatter. View the full list of number transformations.

In this guide, we’ll show you how to use Formatter to perform basic formatting on numbers, such as formatting currency or doing mathematical operations. Before you can add Formatter to a Zap, you’ll first need to set up a trigger.

Formatter by Zapier can also be used to format text, dates/times, and utilities.

1. Add a Formatter step

Click the + icon to add a step.
Select Formatter
Select Numbers from the list of event options.
Click Continue.

2. Set up your options

Choose your transform, which is the specific action that you want to do to the number. There are several types of number transformations. such as formatting currency, formatting phone numbers, performing mathematical operations like addition or subtraction, or using spreadsheet formulas.

When you format a phone number with the Format Phone Number transform, Zapier validates whether or not the "from" phone number is valid in the country code selected (US is the default). Fake phone numbers (e.g., there is no 555 area code in the US), phone numbers with too many or not enough numbers, or phone numbers with invalid characters will result in an unchanged output.

In the Input field, click the dropdown menu and specify the input value by choosing a field from a previous step.

Some transforms will have additional required or optional fields that you can fill out.
Click Continue.

3. Test your formatting

Click Send Test To Formatter by Zapier.

If your test was successful, you'll be able to see the results of your test next to the label output.

Click Continue.

Once you've set up the Formatter step, you'll continue setting up the rest of your Zap by adding another action. Be sure to use the output from the Formatter step in your next action step.

Need More Help?

Modify number formats in Zaps

2. Set up your options

3. Test your formatting

Contact Support

Hire an Expert

Zapier Community