Try this:

=TEXT(n*30,"mmm")

Where n = 1 to 12

--
Biff
Microsoft Excel MVP


"Blaze-Of-Glory" wrote in message
...
Excel 2007 - Why doesn't this work? Being forced to use VLookup and make
a
month table each time I want to convert a month number to a month nme