Prev: Formula Help
Next: Final Reminder - Microsoft Responds to the Evolution of Community
From: Malcolm on 28 May 2010 12:05
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
From: Glenn on 28 May 2010 12:13
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
From: Gord Dibben on 28 May 2010 12:16
Custom Format mmmm, yyyy


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 09:05:01 -0700, Malcolm
<Malcolm(a)discussions.microsoft.com> 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

From: DaveC on 28 May 2010 12:29
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
From: Malcolm on 28 May 2010 13:44
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
 |  Next  |  Last
Pages: 1 2
Prev: Formula Help
Next: Final Reminder - Microsoft Responds to the Evolution of Community