Excel: Format empty date cells

[kogrady]

How do I format empty date cells to be blank instead of displaying 01/00/00 ?

 

[T. Valko]

Is there a formula in the cell?

Try this general approach:

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

 

[MyVeryOwnSelf]

How do I format empty date cells to be blank instead of displaying

01/00/00 ?

If it displays like that, chances are it isn't really empty -- it contains
the number zero.

If you want such cells to display as blank, try
Format > Cells > Custom >
with this in the "Type" box:
mm/dd/yy;;""

 

[Shane Devenshire]

Hi,

try the following custom format:

[>0]m/d/yyyy;

Format, Cells, Number tab, Custom, and enter it on the type line