Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
Convert date + time text format to date format | Excel Worksheet Functions |