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

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

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

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

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

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

.

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