Thread: =Text(n,"mmm") always returns "Jan" when n=1..12
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default =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


Reply With QuoteReply With Quote