MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Blank Date


Posted by Naveen on August 15, 2001 1:19 PM

Hi,

I have a Date column (format - m/dd/yy) which contains some blank values. In my INSERT statement, the blank field displays 1/00/00. I would like to display a blank instead of that weird date. Any ideas?

Thanks for the help.

Naveen

Posted by Mark W. on August 15, 2001 1:28 PM

Format as...

m/dd/yy;;

Posted by Naveen on August 15, 2001 1:56 PM

Hi Mark,

I did format that cell as 3/4/97 (right click --> Date --> 3/4/97). But, no use.

Thanks,

Naveen

Posted by Barrie Davidson on August 15, 2001 2:07 PM

Naveen, Mark means that you need to Custom format (the Custom Format option when you are formatting cells, not Date Format) the cell to that format.

Barrie

Posted by Mark W. on August 15, 2001 2:15 PM

Look again...

The format is...

m/dd/yy;;

...or...

=TEXT(ref,"m/dd/yy;;")

You may have to increase the font size of your
browser window to see the itty bitty semi-colons.