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

Tammy4 wrote:

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