•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Suggestion for correct custom format for an accounting numbers
Hi- can someone help me whats the custom format if i want to make an amount as below:
if negative should be (x,xxx)
if positive should be x,xxx
if 0 should be -
all should be whole numbers
I am currently using _(*#,##_);_(* (#,##);_(* -_)
but its showing () for 0 amount with decimals and negative. I want it to be just - because when rounded it should be 0.
[link] [comments]
Want to read more?
Check out the full article on the original site