DATE FORMATTING

[Maureen]

I work in English and French in Windows XP/Excel 2000 and
would like to obtain the international date format (year-
month-day) for both. My regional settings are French
(Canada) because I work slightly more in French than in
English. This means that when I enter a French text date
in a cell formatted for international, I get 2004-04-14
for today's date. How can I get an English text date to
change to international (2004-04-14) without changing my
regional settings?

Thanks

 

[Frank Kabel]

Hi
in Excel just apply the custom format ('Cells - Format - Custom)
YYYY-MM-DD