How to hide 0.00 on spreadsheet with formula?

[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?

 

[Dave Peterson]

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???)

 

[Bob Phillips]

Go to Tools>Options>View and uncheck Zero Values

 

[Sam Wilson]

Highlight the column(s) and go to Format/Cells and on the 'number' tab and
choose custom - change the type to:

#;;