How can I format a cell so date field only displays the Month?

G

Guest

I'd like to have cells with date fields only display the Month. Instead of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
Thank you.
 
R

Ron Rosenfeld

I'd like to have cells with date fields only display the Month. Instead of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
Thank you.
Click to expand...

Format/Cells/Number Custom: mmmm


--ron
 
C

CLR

Right-click on the cell with the date in it > FormatCells > NumberTab >
Custom > ..type MMMM in the window

Vaya con Dios,
Chuck CABGx3
 
G

Gord Dibben

Format>Cells>Number>Custom.

Enter MMMM in the dialog box.

Gord Dibben Excel MVP
 

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

date format 1
Preserving date format 1
Weird date format problem 2
Conditional formatting of date-cell - 2007 5
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
Excel Date 4
Excel 2002: How to make the date format uniform ? 1
How I convert date formatt of dd/mm/yy to mm/yy (not cell format) 1

Top