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 Format>Cells>Time>Locale 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