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



Reply With QuoteReply With Quote