How to hide 0.00 on spreadsheet with formula?
 

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?

How to hide 0.00 on spreadsheet with formula?
 

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

How to hide 0.00 on spreadsheet with formula?
 

Go to ToolsOptionsView and uncheck Zero Values

--
__________________________________
HTH

Bob

"Tammy4" wrote in message
...
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?

How to hide 0.00 on spreadsheet with formula?
 

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

#;;

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