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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Using =SUM...just can't figure this simple thing out... 2
Newbie Help - IF Yes No Function 0
How do I combine/join multiple formulas 2
Replacing a phrase with carriage returns 1
Expanding Date Formula 0
Returning Multiple Results with Vlookup 1
Table of content - format does not get saved 2

Top