=TEXT(A1,"yyyy mmmm")

--
HTH

Bob Phillips

"
oft.com wrote in message
...
I want to convert a date to year - month ie 15-05-2005 to (2005 May) I
don't
want to use the format option as I need to use a pivot table, and that
would
still use the original date.

I am using Excel 97

Thank you for your help

Michael