C camp732 Jul 29, 2009 #1 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?
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 Jul 29, 2009 #2 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")
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 Jul 30, 2009 #3 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.
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.
