Formatting currencies with Formatter by Zapier
Whether you work with single or multiple currencies in your business, it’s likely that at some point or another, you'll need to convert numerical values into a currency format appropriate to your (or another) locale or to be displayed in a certain way. You can do this easily using the Formatter by Zapier Numbers action event with the Format Currency transform option.
Here are a couple of examples of when you can use this transform option:
- When you want to change the format of a number such as
1,000.23
to a German (Germany) locale format with the comma as the decimal mark, displayed in Euros with the currency symbol at the start, and the currency shortcode at the end, such as€
1.000,23 EUR
- When you want to change the format of a number such as
1000.23
to an English (United States) locale format with the period as the decimal mark, displayed in US dollars with the currency symbol at the start, with no thousands...