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

[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.

 

[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.

Format/Cells/Number Custom: mmmm


--ron

 

[CLR]

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

Vaya con Dios,
Chuck CABGx3

 

[Gord Dibben]

Format>Cells>Number>Custom.

Enter MMMM in the dialog box.

Gord Dibben Excel MVP