How to get currency field formatting which includes comma and $ sign in SharePoint Designer Workflow Email Activity

Problem:

I ran into one issue that by using SharePoint Designer Workflow, when it send email which contains “Currency” field in Email Activity it is not formatting  which shows commas and $ sign. It was irritating.

Solution:

After working on couple of hours, I found out solution (Such a simple) create one calculated column and make that column of String type and put the formula as “=DOLLAR(Amount,2)” and now include that field in Email Activity.

Whoooo!!!!!It is working like charm!!!!

Disha Shah