View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
artemis1027 artemis1027 is offline
external usenet poster
 
Posts: 13
Default Cells showing unwanted information...

I am setting up a control sheet for monitoring visits. I have it set that
when you put in a consumer's start date, it automatically fills in the date
the first visit should be made and so on. My problem is that if I leave a
space blank, it fills in a date from 1900. I know I can use conditional
formatting or something to solve this, I just can't figure it out. Can
someone please help?