Thread: Format Date
View Single Post
  #4  
Old May 28th, 2010, 05:29 PM posted to microsoft.public.excel.worksheet.functions
davec
external usenet poster
 
Posts: 48
Default 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