Hi,

I have a list with time entries

Date Hours worked Month
2008-10-01 4
2008-10-15 6
2008-11-01 3

I would like to add a column to the right with month in text such as oct,
nov in the example above. I have done that with formatting the date column
with "mmm", but when using that data as column data in a pivot-table, oct
appears twice (which is not surprising since it is actually different dates
in the cells even though it only shows month). So, what I think I need is
oct, nov and so on in text format in my month column so that it works in
pivot-tables.

How do I do that?

Thanks in advance,
Peter S