convert number to currency in emails

[johnw]

after POs are booked and my recipe sends emails out to Sales and OMs to let them know what happened the prices are hard to read since there is no formatting.

for example they see:

Op Amount: $3891266.55 (USD)

they would like to see:

Op Amount: $3,891,266.55 (USD)

this seems like it's an easy ask but I can't figure it how to do it

thanks

john 

[johnw]

but either way my whole email body would have to be converted from html to a formula, correct?

[gary1]

You can do it two different ways.

If you do the conversion in a variable before the email action, you can do this:

If you do the conversion in the message itself, you will need to make it a formula like this:

[johnw]

oh so i change my existing body to a formula field and put "" around all the existing html code and do + wherever I have a data pill

[gary1]

That's pretty much it. In my opinion, it's easier and cleaner to do the conversion in a variable and insert it into the text (option 1 above). I'm splitting hairs over a single task, but it makes the email body easier to read and update.

[johnw]

we currently have 5 different price fields in the email but maybe I could get creative and create a single variable with all the different price fields formatted with line fields and then add that