=Text(n,"mmm") always returns "Jan" when n=1..12
n=1 is 1 Jan 1900
n=2 is 2 Jan 1900
n=3 is 3 Jan 1900
....
n=12 is 12 Jan 1900.
Still January.
--
David Biddulph
"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
|