when i try to "format cells" date, choosing English canada, the format will
not apply, it changes to chinese or cyrllic.

I see no such choice of language within Format, cells, Date
with my US version of Excel 2000, no can I imagine such an option..

What are your date formats (short and long) in you Region Options (in control settings).?

What language are you setup for in your control settings.

If you take the cell that has been formatted what do you see if you
look at formatting with Format, cells, customi
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DStanfield" wrote in message ...
when i try to "format cells" date, choosing English canada, the format will
not apply, it changes to chinese or cyrllic.