View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alec alec is offline
external usenet poster
 
Posts: 5
Default From MMDDYY to YYMMDD

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