How to hide 0.00 on spreadsheet with formula?

  • Thread starter Thread starter Tammy4
  • Start date Start date
T

Tammy4

I am using Excel 2003. I am doing a spreadsheet for commissions for sales
reps. Is there a way to not display 0.00 in every cell in a column of the
spreadsheet?
 
You could change your formula:

=if(yourformula=0,"",yourformula)

Or if it's ok to hide all the 0's on the worksheet:
Tools|Options|View Tab|uncheck Zero Values
(xl2003 menus)

Or you may be able to use format|Conditional formatting to hide the 0's. (If
it's 0, show a white font on a white background???)
 
Highlight the column(s) and go to Format/Cells and on the 'number' tab and
choose custom - change the type to:

#;;
 
Back
Top