Hi,

choose Format, Cells, Number tab, Custom and enter the following on the Type
line:

For:
08/01 --- yy/mm
08' 01 --- yy' mm
08' Jan --- yy' mmm

--
Cheers,
Shane Devenshire


"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.