On Dec 15, 7:42 pm, Tom wrote:
Use a custom format and format the cells to "mmmm". If you want that month
returned in a different column, say into column B, then set column B to
custom format ("mmmm"), then =A1 in column B.

I'm a muppet. That's it exactly. Many thanks.

--
Nige Danton