View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default When inserting date , how do I have the month spelled out

try a custom format of

dd, mmm, yyyy

or

dd, mmmm, yyyy

Mike

"Michael K" wrote:

When I want to insert a date in a spreadsheet or document, I do not have the
option of having the month spelled oout as is typically done in a
letter--rather the month of June is represented by the number 6. How can I
have the spelled-out format available in the pulldown when inserting a date?