Convert Currency (dollars & cents) to plain text so shows cents .00
Hi,
How do I get currency (ie. $22.00) to display the cents “.00” when exporting? I have an integromat automation that links Airtable to email and when I use mapping for my dollar amount it only shows the whole number (ie. $22.00 shows 22 – $22.50 shows 22.5).
Thanks!
Page 1 / 1
I know this is probably easy, but I just can’t figure it out. I have been searching and searching, but no luck Any help would be greatly appreciated. I just need my dollars to show cents (ie. “.00” in plain text even when the last numbers are zero. Thank you.
I know this is probably easy, but I just can’t figure it out. I have been searching and searching, but no luck Any help would be greatly appreciated. I just need my dollars to show cents (ie. “.00” in plain text even when the last numbers are zero. Thank you.
I was looking for this for ages and couldn't find it anywhere. I wanted a slight variation where "If the cents = .00, truncate it, else, leave the cents in.
e.g. $32.00 --> $32 | $32.10 --> $32.10
For anyone wanting this solution in the future, here's the slightly adjusted code snippet:
Also, if you use Make (formerly known as Integromat) for your automations — as the original author above said that he was using — you can use Make’s formatNumber function to format the numbers correctly.