T
theE
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december
1=january, 12-december
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sheeloo
There are many ways
1. If you have numbers in Col A starting at A1
enter this in B1
=Date(1,A1,1)
and format the column as
Custom|mmmm
This will show January, ... depending upon the number in A1
Or you can have
=LOOKUP(A1,{1,2,...12},{"January","February",...""December"})
Fill the missing numbers, months
or
you can use VLOOLKUP
=VLOOKUP(A1,Sheet2!A:B,2,False)
if you have numbers in Col A and month names in Col B of Sheet2
or...
1. If you have numbers in Col A starting at A1
enter this in B1
=Date(1,A1,1)
and format the column as
Custom|mmmm
This will show January, ... depending upon the number in A1
Or you can have
=LOOKUP(A1,{1,2,...12},{"January","February",...""December"})
Fill the missing numbers, months
or
you can use VLOOLKUP
=VLOOKUP(A1,Sheet2!A:B,2,False)
if you have numbers in Col A and month names in Col B of Sheet2
or...
D
David Biddulph
=TEXT(DATE(1,A1,1),"mmmm")
or
=DATE(1,A12,1) and format as mmmm
or
=DATE(1,A12,1) and format as mmmm
T
T. Valko
Try this:
A1 = a number from 1 to 12
=TEXT(A1*30,"mmmm")
A1 = a number from 1 to 12
=TEXT(A1*30,"mmmm")
J
Joerg Mochikun
One way (assuming that A1 contains the number):
=CHOOSE(A1,"January","February")
Complete the formula up to December.
Joerg
=CHOOSE(A1,"January","February")
Complete the formula up to December.
Joerg
S
Sheeloo
'beautiful' solution...
T. Valko said:Try this:
A1 = a number from 1 to 12
=TEXT(A1*30,"mmmm")
T
T. Valko
T
theE
Thanks for the help.
T
theE
How do I apply the formula to the rest of the row?