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

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

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;;""

Hi,

try the following custom format:

[0]m/d/yyyy;

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kogrady" wrote:

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