Convert Currency (dollars & cents) to plain text so shows cents .00

Ask the community
#1

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!

#2

I know this is probably easy, but I just can’t figure it out. I have been searching and searching, but no luck :frowning: 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.

#3

I figured it out finally.

For those who need in future:

IF(NOT(FIND(’.’,{REFERENCED NUMBER}&’’)),{REFERENCED NUMBER}&’.00’,
IF(FIND(’.’,RIGHT({REFERENCED NUMBER}&’’,2)),{REFERENCED NUMBER}&""&‘0’,{REFERENCED NUMBER}&""))

1 Like
#4

For future reference, @W_Vann_Hall has demonstration base for formatting numbers as currency to deal with these types of issues.

#5

Thank you. I used formula in his base instead :slight_smile:

#6

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.