Convert Format to $

[bc4]

How do I convert a number to currency with comma and no decimals? For example, I would like 23600.3264 to appear as $23,600 in my summaries and pivot tables. Thanks!

[CharlieS · Accepted solution]

Use the formula in a string field:

"$"+tostring([Field],0,1)  

Keep in mind that once you add the "$" and "," character, this must be a string field. The arguments for the tostring( function are <Field>,<Decimal Places>,<Binary flag to add thousands commas>

[bc4]

worked perfectly - thanks!

[swillson]

Do you know, is there a similar function if the data is numeric? I'm hoping for excel type number formatting that will allow formulas to be written on the data.

[rinair]

I tried to do this its not working for me

[vepp]

try to create a new column and add the formula. Updating the same one might not work.

[suyashkashyap]

Thanks @CharlieS  It was a great explanation.