Format number with currency & decimal to be part of a string

[stephenslaughter]

I am trying to figure out how to format a number (double) into currency and then add as part of a string.  Would this be a formula, regex, or is there an easy way to quickly convert a number to currency?

Program	Year	Cost	Output
Aaaa	2020	500.5	Aaaa (2020) $500.50
Bbbb	2020	600.6	Bbbb (2020) $600.60
Aaaa	2019	7000	Aaaa (2019) $7,000.00
Aaaa	2019	80	Aaaa (2019) $80.00
Bbbb	2019	9090.99	Bbbb (2019) $9,090.99

[allwynthomas24]

Hey @stephenslaughter,

Please check the attached workflow and confirm whether it matches your current requirements.

Thanks & Regards,

Allwyn Thomas

スポイラ

[TonyA]

A couple of people have posted other solutions here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Format-Currency/td-p/828144

[TonyA · Accepted solution]

Just looked through the other solutions and it looks like no one accounted for commas. That makes it a little trickier. I put the formatting in a macro to make this a little cleaner:

[stephenslaughter]

Thanks, TonyA!