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