View Single Post
  #1  
Old 07-06-2005, 04:53 AM
timdee timdee is offline
Registered User
 
Join Date: 06 Jul 2005
Posts: 4
timdee is becoming part of the community
Two quick questions

Firstly, I am using Excel 97 SR-2. My questions are:

If I enter a date in a cell then drag the fill handle down the column it increased by one day each time. Is it possible to create 2 rows with the same date, then the next two increase by one etc. If so, how do I do it?

Secondly, if there is a formula in a cell but no data for it to use it displays ####. Is it possible to stop this until data is entered?
Regards,
Tim.
Reply With Quote