Help converting DATE with MACRO?!

S

SinCity

I have a column that contains dates in a format like this...

25-Mar-05


How would I write a Macro that would take this data and convert it to a
format like this...?

03/25/2005

Thanks much!
 
B

Bob Phillips

Just set the date format, Format>Cells>Custom ... mm/dd/yyyy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
P

Paul B

SinCity, why not just change the format of the column, format cells, date,
and select the one you want?

Or with dates in column A

Columns("A:A").NumberFormat = "mm/dd/yyyy"

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
S

SinCity

Great idea guys - thanks!




Bob Phillips said:
Just set the date format, Format>Cells>Custom ... mm/dd/yyyy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top