Default date format

Our company uses Office 2007 Professional Plus

How do you change the default date format?

I recently replaced a user's PC, and now the dates in his existing Word and
Excel documents are formatted with a four-digit year instead of two. This
has caused many problems with many of his documents, which need to be
reformatted to display correctly.

I have tried changing the short date configuration under Regional and
Language Options in Control Panel to M/d/yy. The dates on Excel sheets are
still displaying 4-digit years.

The workaround would be to format the worksheet with the date format
you want, save the workbook as a template (Filename: book.xltx) in
your XLSTART folder.

Here's a tutorial: http://www.brighthub.com/computing/windows-platform/articles/27366.aspx

--JP

On Oct 6, 8:53 am, "Kevin" <kevi....RemoveThis@community.nospam> wrote:
> Our company uses Office 2007 Professional Plus
>
> How do you change the default date format?
>
> I recently replaced a user's PC, and now the dates in his existing Word and
> Excel documents are formatted with a four-digit year instead of two.  This
> has caused many problems with many of his documents, which need to be
> reformatted to display correctly.
>
> I have tried changing the short date configuration under Regional and
> Language Options in Control Panel to M/d/yy.  The dates on Excel sheets are
> still displaying 4-digit years.