Change number to month.

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??
 
M

muddan madhu

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)
 
R

Roger Govier

Hi
One way
=Date(1,A1,1)
Format>cells>number>Custom> mmm
Copy down as required
 
R

RagDyeR

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??
 
S

ShaneDevenshire

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.
 
Top