Add prefix $ with the number

[Inactive User]

Hi,

I would like add prefix $ in front of the number,

For example, 100 wil be the $100,  1000 will be $ 1,000, 10000 will be $10,000

In the excel, these is function called "accounting number format", i would like to show the same result.

In the Alteryx, is there any similar functions?

Thank you.

[JohnJPS · Accepted solution]

Try a formula tool creating a string field using:

"$" + ToString([number],2,1)

... where [number] is the number you wish to format.