View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Excel: Format empty date cells

Is there a formula in the cell?

Try this general approach:

=IF(your_formula=0,"",your_formula)

--
Biff
Microsoft Excel MVP


"kogrady" wrote in message
...
How do I format empty date cells to be blank instead of displaying
01/00/00 ?
--
Kevin O''''Grady
Woodbridge, VA