In first cell enter 01/01/2006
In second, enter 01/02/2006

Select both cells, drag and copy across or down for 12 cells, then format
them as mmm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Newbie" wrote in message
...
I have 12 months entered as numerics over 12 columns.
How do I display them as months, eg Jan, Feb etc; mmm displays all cells
as
Jan!!