View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Change from mm/dd/yy to yy/mm

Hi,

I have a column with date field in mm/dd/yy format (about 1000 rows).
I would like to duplicate the date field in another column, but convert to
Year/Month (yy/mm). For example: The new column will delete/ignor the dd
format.
04/21/08 count as 08' APR or 08' 04
04/05/08 count as 08' APR or 08' 04
06/15/08 count as 08' JUN or 08' 06

Thanks for any help.