MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Get rid of zero's


Posted by DoughBoy on October 10, 2000 1:28 AM

Can you hide zero's on specific cells.

Have many long formulas and do not want to change any values. Just don't want to see the zero in say cells in top 8 rows. I want to see the zeros in other cells though .

Anyone want to sell me a clue?


Posted by Celia on October 10, 2000 1:38 AM

D'ughb'y
Clue(free of charge) :- IF_Worksheet_Function
Celia


Posted by Ivan Moala on October 10, 2000 2:46 AM

Free of charge.....

Format cells as General;-General;

Ivan


Posted by David on October 10, 2000 10:17 PM

Dont let you post anymore

Posted by DoughBoy on October 12, 2000 1:17 AM

Thank you Ivan, Celia, and of course David