Formatting numbers in currency and percentage in markdown.

Hello ​@rfulda,

Unfortunately, this is one of the most commonly complained about issues with Airtable.

The solution is easy, if a little clunky. Essentially you need to create a text formatted copy of your fields.

For the Currency Field, create a Formula field using the following formula, where the {Amount} field is your Currency Field.

"$" & IF({Amount}, REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( ROUNDDOWN({Amount},0)&"", "(\\d{3})$", ",$1"), "(\\d*)(\\d{3}),", "$1,$2," ), "(\\d{1,3})(\\d{3}),", ",$1,$2," ), "(\\d{1,3}),(\\d{3}),", "$1,$2," ), "^(\\d{1,3})(\\d{3}),", "$1,$2," ), "^,", "" )& "." & LEFT((ROUND({Amount},2)-ROUNDDOWN({Amount},0))*100 & "0", 2) & " ")

You can just use the Find function (CTRL+F in the formula field) to replace the {Amount} with your field name.

Then in your email automation, use this new formula field as the input instead of the {Amount} field.

For the Percentage, this one is a little simpler, do the same as above but use this formula instead, where the {Percent} field is your percentage field.

IF({Percent},
   ROUND({Percent}, 0) & "%",
   BLANK()
)

Then do the same as before, inserting this formula field into your email automation instead.

Hope that helps!