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