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?