converting numbers to months

[theE]

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

 

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

 

[T. Valko]

Try this:

A1 = a number from 1 to 12

=TEXT(A1*30,"mmmm")

 

[Joerg Mochikun]

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

Complete the formula up to December.

Joerg

 

[Sheeloo]

'beautiful' solution...

Try this:

A1 = a number from 1 to 12

=TEXT(A1*30,"mmmm")

 

[T. Valko]

Thanks!

--
Biff
Microsoft Excel MVP

'beautiful' solution...

 

[theE]

Thanks for the help.

 

[theE]

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