Use an IF statement
Suppose you want to display cell J1 only when it is not blank
=IF(ISBLANK(J1),"",J1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"willemeulen" wrote in message
...
On sheet1 I complete all info displayed spread over other sheets of
which many information is repeated. So I have a direct reference to
sheet1 and only need to complete this information once. My problem is
with the dates for revisions. I only complete a date for the revision
when there is actually one
Sheet 1
Revision No. Issued
1 mar 09
2 apr 09
3
4
etc
When i reference date's directly to empty cells, in this case like for
revision 3 is not done (could or could not be done at a later stage) so
the cell is empty. Now all referenced cells display jan 00, how do I get
around it to let excel display nothing and only show a date when I
actually submitted a date in the mother cell.
Thanks
--
willemeulen
Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile:
http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99763