Here's how it works...

**Only works using the default date system.

1*30 = serial date 30 = Jan 30 1900
2*30 = serial date 60 = Feb 29 1900 (1)
3*30 = serial date 90 = Mar 30 1900
4*30 = serial date 120 = Apr 29 1900
5*30 = serial date 150 = May 29 1900
6*30 = serial date 180 = Jun 29 1900
7*30 = serial date 210 = Jul 28 1900
8*30 = serial date 240 = Aug 27 1900
9*30 = serial date 270 = Sep 26 1900
10*30 = serial date 300 = Oct 26 1900
11*30 = serial date 330 = Nov 25 1900
12*30 = serial date 360 = Dec 25 1900

(1) Excel incorrectly identifies Feb 29 1900 as a leap day/year. This is
well known and is "intentional".

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
For those who might be interested in this method, the numbers 28, 29 and
30 can all be used as the multiplier.

--
Rick (MVP - Excel)


"T. Valko" wrote in message
...
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