i have a cell that has a date in it

[smiley0q0]

i have a cell that has a date in it, i want another cell that to look at that cell and show the month only in its text form. so...

cell b2 = 8/1/01
cell a3 = i want to see "August".

how would i go about doing this?

Thanks,
Smileyy X-)

 

[Databaseguy]

Go to format/cells/custom. Type in MMMM and apply the format.

 

[snyderj]

You could reference the cell (in A3 have =B2), then format A3 to have the custom format of mmmm. The value of the cell will be the same as B2, but the display will only be the month.

 

[Goska]

You could do a =month(b2), then a Vlookup of some table that you made. The month function returns 1-12, so make a 2 column table of 1-12 and Jan-Dec, and use this for your output.

 

[smiley0q0]

WOW, What a response!!! Thank you guys, i appreciate your help. i got it to work. i used Goska's idea... it was a little more fun
Thanks again.. :-V