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

T

tk_2u

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
 
Top