On Thu, 16 Nov 2006 12:18:13 -0000, "Roger Govier"
wrote:

=TEXT(A1&"-1","mmm")
Neat solution!! but I think you meant to reference cell A2 not A1.

Also, dependant upon your regional settings, (in the UK for example) you
would need to use
=TEXT("1-"&A2,"mmm")

That's an advantage of using the DATE worksheet function -- it is not locale
dependent.


--ron