If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format Date
Hi, all,
How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm |
#2
|
|||
|
|||
Format Date
Malcolm wrote:
Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm Custom date format: mmmm, yyyy |
#3
|
|||
|
|||
Format Date
Custom Format mmmm, yyyy
Gord Dibben MS Excel MVP On Fri, 28 May 2010 09:05:01 -0700, Malcolm wrote: Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm |
#4
|
|||
|
|||
Format Date
right, format cells, in the general tab select custom, and if not already an
option to select from, type mmm, yyyy If this helps, please press yes "Malcolm" wrote: Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm |
#5
|
|||
|
|||
Format Date
Thanks to Dave C, Glen, and Gord. They all worked
Malcolm "Malcolm" wrote: Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm |
#6
|
|||
|
|||
Format Date
Gord, Hi,
This worked, thanks. Regards, Malcolm Malcolm "Gord Dibben" wrote: Custom Format mmmm, yyyy Gord Dibben MS Excel MVP On Fri, 28 May 2010 09:05:01 -0700, Malcolm wrote: Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm . |
#7
|
|||
|
|||
Format Date
DaveC, Hi,
Thanks dude. Malcolm "DaveC" wrote: right, format cells, in the general tab select custom, and if not already an option to select from, type mmm, yyyy If this helps, please press yes "Malcolm" wrote: Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm |
Thread Tools | |
Display Modes | |
|
|