Date format Excel97 to Excel2002

Giganews Newsgroups
Subject: Date format Excel97 to Excel2002
Posted by:  Rohan (anonymo…@discussions.microsoft.com)
Date: Tue, 28 Oct 2003

In excel97 we used the date format dd-mm-yy.

The same spreadsheet opened in Excel2002 shows the format
as Custom d-mm-yy even though the date format dd-mm-yy
option exists.

I do not want to reformat the hundreds of spreadsheets we
use.  Does anyone have any info on this.

Thank you

Replies