On Thu, 27 May 2004 15:36:13 -0400, Ron Rosenfeld
wrote:

On Thu, 27 May 2004 11:50:36 -0700,
wrote:

I need some code to:
I have a column (F) that contains dates and zeros. How
can I change the format to date (YYYYMMDD) and leave the
zeros as zeros and not get the 19000100 date?

0
6/7/2004
7/19/2004
0
0
0
0
0
1/31/2005
3/14/2005
9/13/2004
10/18/2004
1/31/2005
7/12/2004


Format/Cells/Number
Category: Custom
Type: [=0]0;yyyymmdd


--ron

I missed that you wanted VBA code to do this:

Range("F:F").NumberFormat = "[=0]0;yyyymmdd"



--ron