Change number to month.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

I've got a bunch of numbers from 1 - 12 that represent months. How can I
change all those numbers and instead of having a 1, have January or instead
of a 9 have September??
 
try suppose u have number in A1 then put this in B1

=INDEX({"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"},A1)
 
Try this:

=TEXT(DATE(,A1,1),"mmmm")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I've got a bunch of numbers from 1 - 12 that represent months. How can I
change all those numbers and instead of having a 1, have January or instead
of a 9 have September??
 
Hi,

If you want a shorter formula:

=TEXT(A1*30,"mmmm")

Will do it. Or even shorter:

=A1*30
and then format the cell with Format, Cells, Number tab, Custom, and enter
MMMM in the Type box.


If you find answers useful you should click the Yes button for all each post.
 
Back
Top