Alec

This works for me.

Select the column then DataText to ColumnsNextNextColumn Data
FormatDateMDYFinish

Now Custom Format to YYMMDD


Gord Dibben Excel MVP

On Wed, 28 Sep 2005 09:21:06 -0700, "Alec"
wrote:

Hey Guys,

I have a column of dates in a text format as MMDDYY. I need to turn it into
YYMMDD. I have so many rows that I dont see myself manually reformating each
row of data to the YYMMDD format.

How can I code this to do it automatically for the whole column?

Thanks for your help. It is always appreciated.

Alec