Sorry I am still not clear

There are two Sheets

* In one sheet the user will enter the number of a month... Lets say 1 for
Jan....
* The other sheet will look at the number the user as entered in that cell
and will PRINT the name of the month in that cell

I tried to write something like this:

IF(Main_Sheet!B2=1,"JANUARY"), if(Main_Sheet!B2=2,"FEBRUARY")....... goes
upto december

Please help...

thanks...

"Andrew Taylor" wrote:

...or, for less typing: =TEXT(DATE(1,A1,1),"mmmm")


Roger Govier wrote:
Hi

Try
=CHOOSE(A1,"January","February","March", ,,,,,, ,"December"))
Fill in the complete range of Months in upper or lower case as you
prefer.
--
Regards

Roger Govier


"Deezel" wrote in message
...
Hi there,

I am trying to write this formula. There are 2 sheets in spreadsheet I
am
using refernce from this one cell that has numbers in there.

In another sheet i am refernceing it in an If STMT the Cell has 1, The
cell
in the next sheet will select "January". Something like this for all
12
months:

IF(Main_Sheet!B2=1,"JANUARY"), if(Main_Sheet!B2=2,"FEBRUARY"),
IF(Main_Sheet!B2=3,"MARCH"), IF(Main_Sheet!B2=4,"APRIL"),
IF(Main_Sheet!B2=5,"MAY"), IF (Main_Sheet!B2=5,"MAY"),
IF(Main_Sheet!B2=5,"MAY"), IF (Main_Sheet!B2=6,"JUNE"), IF
(Main_Sheet!B2=7,"JULY"), IF(Main_Sheet!B2=8,"AUGUST"),
IF(Main_Sheet!B2=9,"SEPTEMBER"), IF(Main_Sheet!B2=10,"OCTOBER"),
IF(Main_Sheet!B2=11,"NOVEMBER"), IF(Main_Sheet!B2=12,"DECEMEBR")


Please help me out with this formula. Thanks