A line item amount comes out of Stripe in cents like below for a $22 sale:
2200
How does one use the Formatter currency function to convert 2200 to $22.00.
Zapier documentation directs me to this page but I can’t wrap my head around the unicode stuff.
http://www.unicode.org/reports/tr35/tr35-numbers.html#Number_Format_Patterns
Any help would be appreciated.
Thanks!
Hi
Have you taken a look at our little nifty video of how to use Formatter by Zapier to format currency? It looks like the unicode to select is this one: #,##0.##
Could you give it a try and let me know if that worked for you?
That format didn’t work but I found a simple solution.
Take the 2200 amount from Stripe and use the Formatter Math Problem operation and divide that amount by 100 to get the decimals I wanted 2200 → 22 (i.e. if the amount was 750 dividing by 100 would yield 7.5).
22 → Formatter Currency gave me the $22.00 I was looking for (7.5 → $7.50).
Yay MATH!
I hope you have a wonderful rest of your day!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.