Date format Excel97 to Excel2002

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
 
D

Dave Peterson

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.
 
Top