Help

Modify number formats in Zaps

Last updated:

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.

Tip

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.
Note

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?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community