I know I can set Excel to either show zeros or not show zeros by going into advanced options, but my boss is obnoxious and wants to show zeros on half my spreadsheet, and not show it on the other half ><
I know I can set the formulas to say IF(formula=0,0,formula), but that's going to make me have to update it every month. Does anyone know of another way?
Highlight the cells you want a blank to show instead of a zero, then use custom formatting and enter this 0;-0;;@ in the type field. This will display a blank for those cells that have a 0 in them.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Perhaps format the half where the 0 should not be shown the same colour as the background using Custom Format like [white](0.00)
See, just because of your boss you are here to learn something new.Originally Posted by AstToTheRegionalMGR
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
What does he think of dashes?
If you use the Accounting format as a base and take out the dollar signs in a custom format, you would only have a dash.
If this helped, please click (*) Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks