...change the default date in the Header of an Excel...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Shum
Submitted on 7/25/2003
Related FAQ: comp.apps.spreadsheets FAQ
Rating: Not yet rated	Rate this question:
How do I change the default date in the Header of an Excel spreadsheet. I would like the default to read 25-Jul-2003 instead of 25-07-03. Thanks.

Answer by Harry T Hill
Submitted on 3/6/2004
Rating: Not yet rated	Rate this answer:
http://support.microsoft.com/?kbid=213742 You have to change the ENTIRE date format in Regional Settings in the Cntl Panel.In the individual cells....change anyway you want. Crazy eh?

Answer by Harry T Hill
Submitted on 3/14/2004
Rating: Not yet rated	Rate this answer:
Check MS Knowledge Base 213742

Answer by Taco Barbarian
Submitted on 12/30/2004
Rating: Not yet rated	Rate this answer:
This is not true! The date format on headers/footers do NOT take the format from the general Windows settings. There appears to be no way to change the format at all! There is a Microsoft knowledge "fix" but it simply hard-codes the current date in your desired format. This then does not get updated in the future. A macro for something that you might as well simply type in by hand and save the trouble! Help would be appreciated...

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: