View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDB JDB is offline
external usenet poster
 
Posts: 42
Default Using Date & Time Custom Cell - Need to show blank!

I have a column with the cells formatted to show dd/mm/yyyy hh:mm. There is
also a formula that adds a day if certain conditions are met. When I copy
this formula down so that every cell has it, the cells on rows that haven't
been used yet show as 01/01/1900 00:00. How do I show these as blank cells -
the sheet is quite confusing otherwise!