Excel Currency Tips
If you’re like me you use Microsoft Excel nearly every day. Often I’m working with money, which I don’t think is uncommon, and very often find myself reformatting my cells with the Accounting Number Format ($) button in the “Number” group on the Home tab of the ribbon section. Maybe you do too?
But every time I do this, Excel tries to help when I didn’t ask for it. Excel will auto format my number as $$$$.$$ with both dollars and cents. Yeah, great, but not what I usually want. Occasionally I’m calculating my candy budget and I do need the extra decimal places but normally I’m more interested in the rounded dollar amount and want a cleaner looking Excel sheet. So nearly every time I format to Accounting Number style, I also immediately double tap the “Decrease Decimal” button so my format returns to zero digits past the decimal.
No biggie, right? Except, yes biggie! I hate doing it. It’s a wasted step and that extra 2 clicks every day for the past decade has added up. But not anymore. I have a quick hack if you want to fix this same problem for yourself.
Turns out the issue isn’t with Excel as much as it is with Windows. Go to Start –> Settings and search for “change the way currency is displayed.” In that form, select “Additional settings…” and on the “Currency” tab you’ll find “No. of digits after decimal” setting. Select 0 and you’re all set!