•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#custom format
#negative
#positive
#whole numbers
#accounting
#amount
#decimals
#0 amount
#formatting
#(x,xxx)
#x,xxx
#-
#rounding
#Excel