Copy and paste the entire column to where you want it. Then highlight the
new column and do Right-click FormatCells NumberTab then either choose
DATE and select one of the optional formats, or choose CUSTOM and choose one
of those offereings, or create your own format.

Vaya con Dios,
Chuck, CABGx3



"Cam" wrote:

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.