Thread: Format Date
View Single Post
  #3  
Old May 28th, 2010, 05:16 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
  
Posts: 20,252
Default 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