Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Blank DatePosted by Naveen on August 15, 2001 1:19 PM
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.
Re: Blank DatePosted by Mark W. on August 15, 2001 1:28 PM
Re: Blank DatePosted by Naveen on August 15, 2001 1:56 PM
I did format that cell as 3/4/97 (right click --> Date --> 3/4/97). But, no use.
Re: Blank DatePosted 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.
Look again...Posted by Mark W. on August 15, 2001 2:15 PM
The format is...
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.