Date format Excel97 to Excel2002

  • Thread starter Thread starter Rohan
  • Start date Start date
R

Rohan

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
 
I think you got hit by a coincidence.

When you do Format|cells|Number tab and look at that cell's format, I'm betting
you see something like:

*14/03/2001

That asterisk means that you chose a short date format that is picked up from
the Windows Regional settings (Date tab).

Also from the bottom of that dialog:

Date formats display date and time serial numbers as date values. Except for
items that have an asterisk (*), applied formats do not switch date orders with
the operating system.

Since yours is marked with an asterisk, your date will switch formats with the
setting in the OS.
 
Back
Top