Can't change date format in Excel footer

R

rkoett

I have a client running Office 2003 Standard Edition on Windows XP
Professional. Both products are fully patched via Microsoft Update. Regional
& Language Options are set to English (Canada). The short date format is
shown as 22/01/2007. This is the desired format.

In Excel, however, when my client inserts a Date field in a footer, the date
field appears with the format 01/22/2007.

How can we modify the format of a date field that appears in a footer?

Thanks,
Richard.
 
L

Leon Hao [MSFT]

Hi Richard,

As far as I know, Excel uses the Short date style format specified under
Regional Settings in Control Panel. The default date format for English
(Canada) is dd/mm/yyyy, and the date your client inserted as footer in
Excel should also be the same format. So I would like to confirm with you
if the regional setting is right on your side. To make it clear, I have
attached a screenshot for your reference.

If the setting is right and the problem still persists, then please try the
following tests and tell us the test results. This will help us narrow down
this issue quickly.

* Test 1: Start Excel with /s switch
=======================

1. Click Start>Run
2. Type Excel /s and click OK.
3. After Excel starts, please insert a date filed into the footer and
determine if this issue is gone.

* Test 2: Use another Windows account
=======================

Please use another Windows account to log on the system and see if the
issue is gone. Please also create a new user account to test. This will
eliminate the possibility that this user account is corrupted or damaged.

If your problem still occurs, please help us collect more information for
further research:

* Information Collection
================

1. Select a blank cell within a worksheet and hit CTRL+; (this will insert
a date in the selected cell). Does the date format display right?
2. Please provide an MPS_REPORT so that we can do further research.

Obtaining an MPS_REPORT
------------------------------------
1. Go to the following web page:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
88B7-F9C79B7306C0&displaylang=en
2. Click to download MPSRPT_SETUPPerf.EXE
3. Double click to run this EXE file.
4. After a few minutes, a CAB file will be generated. Please send the CAB
file directly to my mail box.

Here is the detailed information about MPS_REPORT:
818742 Overview of the Microsoft Configuration Capture Utility (MPS_REPORTS)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;818742
------------------------------------

Here is my Email address: <[email protected]>

Please try the suggestions and update with the information and results. If
you have any questions please do let me know.


Regards,

Leon Hao

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
R

rkoett

Leon:

I tried the troubleshooting steps you suggested. The problem persisted in
each case. I have produced an MPS Report file, but since I don't know how to
attach a file using this web interface I have placed the CAB file here for
you:

ftp://cybernet.ca/uploads/ANGELA-DESKTOP_MPSReports.CAB

Please advise what step(s) I should take next.

Thanks,
Richard.
 
L

Leon Hao [MSFT]

Hi Richard,

I have tried a lot of time but failed to visit your ftp site.

I think you can use Outlook Express to attach the files. Or, alternatively,
you can send them directly to me via: <[email protected]>

I'm looking forward to your update.


Regards,

Leon Hao

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
L

Leon Hao [MSFT]

Hi Richard,

I have received your e-mail and CAB file. We are currently doing research
on this issue. I will get back to you as soon as possible. Thanks for your
patient.


Regards,

Leon Hao

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
L

Leon Hao [MSFT]

Hi Richard,

I have analyzed your MPS report but failed to find anything unusual. Please
provide some additional information as below:

1. Create a new workbook in Excel. Choose one cell and hit the combination
key "CTRL+;". Does the right date format displayed in that cell?
2. You said the date format in footer is not correct. Then what about in
header? Does it correct when you insert the date field in header?
3. Does this also occur when you insert the date in a Word document?

Meanwhile, I would like to suggest as below:

Before we start, please be sure that the Regional and Language is set to
English (Canada).

* Perform a Clean Boot in Windows XP
======================

1. Click Start>Run, type "msconfig" in the Open box (without the quotation
marks), and then click OK.
2. On the General tab, click Selective Startup, and then clear the Process
System.ini File, Process WIn.ini File, and Load Startup Items check boxes.
You cannot clear the Use Original Boot.ini check box.
3. On the Services tab, select the Hide All Microsoft Services check box,
and then click Disable All.
4. Click OK, and then click Restart to restart your computer.
5. After Windows starts, determine whether the symptoms still occur.

If it works fine after Windows clean boot, please obtain the detailed
troubleshooting steps in our KB article:

310353 How to perform a clean boot in Windows XP
http://support.microsoft.com/default.aspx?scid=kb;EN-US;310353

* Perform a Safe Mode in Windows XP
=======================

1. Restart Windows.
2. At the boot sequence, long press F8 key to invoke startup menu.
3. Choose Safe Mode on the menu and press Enter.
4. After Windows starts in Safe Mode, determine if this issue still
persists.

Please try the suggestions and update with the information. Thanks.


Regards,

Leon Hao

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top