How to remove decimal places from currency formatting in ArcGIS?

Question

For years I have put up with the 2 decimal places that ArcGIS adds to the "currency" formatting, but most of the time I do not want them and end up removing them in my exported map images. I cannot see a way to edit the number of decimals - does anyone have any ideas how to get rid of these decimals?

Answer 1

EDIT: There may be some business reason you need to have the field set to currency but I think I would manage it in a different way.
Anyway you can also always round the result before displaying the label.

Since it say localized currency settings you might try looking at the windows settings for your computer.

To change the way your computer displays currency values, click the Currency tab. Items you might want to change based on the format language you choose include the currency symbol, the formats used for positive or negative amounts, and the punctuation used to separate numbers.

OLD: If you open the attribute table.
Go to the field you want to modify.
Right click and select properties.
on the properties it should say numeric... Select the ... In that format dialog you will see the number of decimals.
Turn it to 0

Answer 2

You could use Brad's answer in conjunction with a label expression that adds the dollar sign (or other appropriate currency symbol).

VBScript example:

"$" & [CHA_CHING]