| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display month only for date format?
Does anyone know how to display the month only for date format?
such as 26 Sep, 2006, it displays Sep only. Thank you for any suggestion Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display month only for date format?
Hello, Eric!
You wrote on Sun, 24 Sep 2006 06:46:02 -0700: E Does anyone know how to display the month only for date E format? such as 26 Sep, 2006, it displays Sep only. E Thank you for any suggestion E Eric Have a look at Special Format: mmm gives Sep and mmmm September (today's date anyway!) James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display month only for date format?
"Eric" wrote in message
... Does anyone know how to display the month only for date format? such as 26 Sep, 2006, it displays Sep only. mmm -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| How do I display this data in a differnet format? | Excel Discussion (Misc queries) | |||
| How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
| Display Format with Text & Formula | Excel Worksheet Functions | |||
| I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
Linear Mode
