Cell formatting

C

camp732

I have this formula =MONTH(J8) in the cell but it is returning the # for the
month. How do I format it to return the month spelled out?
 
G

Glenn

camp732 said:
I have this formula =MONTH(J8) in the cell but it is returning the # for the
month. How do I format it to return the month spelled out?
Click to expand...

=TEXT(J8,"mmm")

=TEXT(J8,"mmmm")
 
S

Shane Devenshire

Hi,

If you just want to see it as a month replace =MONTH(J8) with =J8
and then choose Format, Cells, Number tab, Custom, and enter MMMM on the
Type line.
 
Top