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

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

Thanks for the reply. However, I want to know how to format the date in the
header, not in the worksheet. Can you help?
--
Thanks.
Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7


"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

Hi,
there was a solution given by Ron de Bruin with a VBA code

You can use the format function
Copy this event in the Thisworkbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Sheets
sht.PageSetup.LeftFooter = Format(Now, "*March 14,2001")
Next sht
End Sub


"Sammie" wrote:

Thanks for the reply. However, I want to know how to format the date in the
header, not in the worksheet. Can you help?
--
Thanks.
Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7


"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

The only way to custom format a date in a header or footer is by VBA

Sub add_date_header()
ActiveSheet.PageSetup.LeftHeader = Format(Date, "mmmm dd, yyyy")
End Sub


Gord Dibben MS Excel MVP


On Fri, 15 Jan 2010 06:00:01 -0800, 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?

Hi Sammie,

To change the format of the date in the header from 1/15/2010 to January 15, 2010, you can follow these steps:

1. Double-click on the header to enter the header editing mode.
2. Click on the "Design" tab in the ribbon.
3. Click on the "Header/Footer Elements" dropdown menu.
4. Select "Date" from the list.
5. Click on the "More Formats" button in the "Header/Footer Elements" dropdown menu.
6. Select "Custom" from the list.
7. In the "Type" field, enter "MMMM d, yyyy" (without the quotes).
8. Click on the "OK" button to close the "Format Cells" dialog box.
9. Click on the "OK" button to close the "Header/Footer Elements" dropdown menu.

Now the date in the header should be displayed in the format of "January 15, 2010".

Alternatively, if you want to format the date as 15-Jan-2010, you can follow these steps:

1. Double-click on the header to enter the header editing mode.
2. Click on the "Design" tab in the ribbon.
3. Click on the "Header/Footer Elements" dropdown menu.
4. Select "Date" from the list.
5. Click on the "More Formats" button in the "Header/Footer Elements" dropdown menu.
6. Select "Custom" from the list.
7. In the "Type" field, enter "dd-mmm-yyyy" (without the quotes).
8. Click on the "OK" button to close the "Format Cells" dialog box.
9. Click on the "OK" button to close the "Header/Footer Elements" dropdown menu.

Now the date in the header should be displayed in the format of "15-Jan-2010".