Rocky, the first code I posted was the same as yours, I know it should work
but I tried recording it to make sure it was right, running this on 2000 at
this time

--
Paul B
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Rocky McKinley" wrote in message
...
Hi Paul,

I tried the code and it worked for me. One small side note, you don't
have
to use selection to do most actions in Excel, the following code will
achieve the same thing.
Also Excel 97 does have some strange bugs.

Columns("A:A").NumberFormat = "m/d/yy"

Regards, Rocky McKinley

"Paul B" wrote in message
...

I have this line of code Columns("A:A").NumberFormat = "m/d/yy" which
should format the column as 8/23/03, but when I run it, it formats the
column as 08/23/2003, when I look at the cell format after I run the
code
it
is custom mm/dd/yyyy.
I recorded a macro changing the format and got this
Columns("A:A").Select
Selection.NumberFormat = "m/d/yy"
When I was recording it the dates changed to the right format but when I
ran
the macro it changed them to 08/23/2003, what is going on here? This
happens
in any workbook I run the code on. Thanks for any ideas


--
Paul B
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **