View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Format date in header

Hi,
right click on the mouse in the cell where you have the date, format cells,
date, choose *March 14,2001 to get January 15,2010

"Sammie" wrote:

I use the date button to insert the date in the spreadsheet header &[Date] ,
and I want to change the format of the date from 1/15/2010 to January 15,
2010. How do I do that?

Alternatively, what's the format for 15-Jan-2010?

--
Thanks.
Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7