Jason Morin wrote:
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


Thanks, but that's not really the problem. Excel 2003 is taking its
default date/time option from the settings on the PC. However, because
someone at Microsoft seems to think that we in the UK express times as
hh/mm/ss rather than just hh/mm, if I need to format a cell as a time I
have to set FormatCellsTimeLocale to 'English US'. This, however,
sets the Locale for my dates to 'English US', too, so when I want to
format a Date, I have to change my Locale back to 'English UK', thus
resetting my time format ....

What I really want to do is tell Excel 2003 that by default I want to
use a dd/mm/yy format for my dates and a hh/mm format for my times, just
as I could do in Excel 2000. Is it possible?

Steve