K kogrady Jul 8, 2009 #1 How do I format empty date cells to be blank instead of displaying 01/00/00 ?
T T. Valko Jul 8, 2009 #2 Is there a formula in the cell? Try this general approach: =IF(your_formula=0,"",your_formula)
M MyVeryOwnSelf Jul 8, 2009 #3 How do I format empty date cells to be blank instead of displaying 01/00/00 ? Click to expand... 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;;""
How do I format empty date cells to be blank instead of displaying 01/00/00 ? Click to expand... 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;;""
S Shane Devenshire Jul 8, 2009 #4 Hi, try the following custom format: [>0]m/d/yyyy; Format, Cells, Number tab, Custom, and enter it on the type line
Hi, try the following custom format: [>0]m/d/yyyy; Format, Cells, Number tab, Custom, and enter it on the type line
