Hi,

If you want to suppress all the zeros in the worksheet, then go to
Tools-Options, View Tab and uncheck 'Zero values'. This will suppress
all zero values in that specific sheet..

Regards

Govind.

kimmer4861 wrote:
I have a master workbook that I use to compile entries from about 25
different individual's workbooks. I have a page for each person set up
and was just using a formula
"=[workbook_name]sheet_name!cell_reference"(i.e. ='[Auditor Savings Jan
06.xls]Audits'!$A$29). As the month goes on, each individual creates
entries and those lines are fine. My problem is that a line that does
not yet have data entered is showing up on my master as either "0" or
1/0/00. Is there a way to have the master page just show as blank when
the data page doesn't have anything entered yet? I tried using
conditional formatting (if cell is equal to 0), but that didn't do
anything. Any suggestions?