Thread: Hiding dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bryan
 
Posts: n/a
Default Hiding dates

Hi,

I have created a workbook which has a number of fields in worksheet one.
When data is keyed into this sheet the two other sheets in the workbook are
populated.

One of the sections requires dates to be put in.
When no date is entered the other sheets default to "00/01/1900". is there
a way of keeping these cells blank until a date is entered in the first sheet?

Thanks,
bryan