converting numbers to months
 

hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

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

"theE" wrote:

hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

=TEXT(DATE(1,A1,1),"mmmm")
or
=DATE(1,A12,1) and format as mmmm
--
David Biddulph

"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

Try this:

A1 = a number from 1 to 12

=TEXT(A1*30,"mmmm")

--
Biff
Microsoft Excel MVP


"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

One way (assuming that A1 contains the number):
=CHOOSE(A1,"January","February")

Complete the formula up to December.

Joerg



"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

'beautiful' solution...

"T. Valko" wrote:

Try this:

A1 = a number from 1 to 12

=TEXT(A1*30,"mmmm")

--
Biff
Microsoft Excel MVP


"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

Thanks!

--
Biff
Microsoft Excel MVP


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
'beautiful' solution...

"T. Valko" wrote:

Try this:

A1 = a number from 1 to 12

=TEXT(A1*30,"mmmm")

--
Biff
Microsoft Excel MVP


"theE" wrote in message
...
hi, how do i convert a list of numbers to their parrallel months? eg.
1=january, 12-december

converting numbers to months
 

Thanks for the help.

converting numbers to months
 

How do I apply the formula to the rest of the row?