Maybe

=TEXT(A1,"mmm")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...


Brilliant Thank you to both of you.

I'll push my luck now!, is there any easy way to get e.g. 01/02/08 or
01-Feb-08 to change to Feb so that in my previous example its sees
them both as the same thing and not formated to be that. I have tried
using =month(a1) but it doesnt always seem to return the correct
Month. So am having to type in the related month. This is ok except
if the core data changes it will not automatically update.

Thanks again for all your help

Mags