software

I created a workbook that has a summary page with cells that link to cells in
other pages of the workbook. These cells are in date format. When there is
no entry in the cells of the other pages, the summary page cell shows
1/01/1900. I would like the cell on the summary page to be blank if the
linked cell is blank. Does anyone know how to do this?
--
Thanks

One way to do it (if it doesn't conflict with some other requirement
that you might have) ...
Turn off display of zero values by going Tools / Options and clearing
the tick next to Zero Values.

Rgds,
ScottO

quot;Nutsquot; gt; wrote in message
...
| I created a workbook that has a summary page with cells that link
to cells in
| other pages of the workbook. These cells are in date format. When
there is
| no entry in the cells of the other pages, the summary page cell
shows
| 1/01/1900. I would like the cell on the summary page to be blank
if the
| linked cell is blank. Does anyone know how to do this?
| --
| Thanks
=IF(Linked_Cell=quot;quot;,quot;quot;,Linked_Cell)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;Nutsquot; gt; wrote in message
...
gt;I created a workbook that has a summary page with cells that link to cells
gt;in
gt; other pages of the workbook. These cells are in date format. When there
gt; is
gt; no entry in the cells of the other pages, the summary page cell shows
gt; 1/01/1900. I would like the cell on the summary page to be blank if the
gt; linked cell is blank. Does anyone know how to do this?
gt; --
gt; Thanks