Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
On Fri, 3 Dec 2004 16:35:01 -0800, "tk_2u"
wrote: 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 |
#3
![]() |
|||
|
|||
![]()
Right-click on the cell with the date in it FormatCells NumberTab
Custom ..type MMMM in the window Vaya con Dios, Chuck CABGx3 "tk_2u" wrote in message ... 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. |
#4
![]() |
|||
|
|||
![]()
FormatCellsNumberCustom.
Enter MMMM in the dialog box. Gord Dibben Excel MVP On Fri, 3 Dec 2004 16:35:01 -0800, "tk_2u" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
How can I defeat Excel's auto-reformating into date format? | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |