You can change the default date/time format (at least in
XP) under Start Control Panel Date, Time, Language,
and Regional Options.

HTH
Jason
Atlanta, GA

-----Original Message-----
Being in the UK, I obviously want to use the English(UK)
date format, so
Christmas Day is 25/12/05 rather than 12/25/05.
However, this defaults
the time format to hh/mm/ss (why, I do not know, since I
can assure
American readers we're not normally that precise), so I
have to reset it
English(US) to get hh/mm, which resets the default date
format to
mm/dd/yy, so I have to change it back the next time I
want to format a
cell as a date.

Any way round this? It's only a minor problem but it's
irritating me.

Steve
.