Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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

Re: Blank Date

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

Format as...

m/dd/yy;;

Re: Blank Date

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

Re: Blank Date

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

Look again...

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

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.