Hi-
if you'd like to change the format of one cell, select the cell and
reformat it.
After selecting the cell, go tot he format menu, choose the first
option: cells.
From the pop-up form, goto the Number tab (should be the first one)-
in the category section- choose date, in the locale section choose
English(Canada)-
then choose the format in the Type section. choose OK.
It should work.
If this is not what you ment, please let me know. Also, indicate what
you've tried and why it hasn't worked-
Good Luck!
pim


--
Pim
------------------------------------------------------------------------
Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565
View this thread: http://www.excelforum.com/showthread...hreadid=470919

Thanks, I tried that, it works in My Office 2003, i wonder if there is a bug
in 2002, I have multiple users with the same problem. No matter what
language they pick, the format does not apply. It will change to Cyrillic or
Afrikaans or Chinese. You could apply the format to the entire sheet with
Date (english canada)save it reopen it and it will defauly to another
language. I even tried creating the sheet on my 2003 system formatting to
date English Canada which works, but once I send it to the users with 2002,
it defaults back to one of the languages formats listed above.

"Pim" wrote:


Hi-
if you'd like to change the format of one cell, select the cell and
reformat it.
After selecting the cell, go tot he format menu, choose the first
option: cells.
From the pop-up form, goto the Number tab (should be the first one)-
in the category section- choose date, in the locale section choose
English(Canada)-
then choose the format in the Type section. choose OK.
It should work.
If this is not what you ment, please let me know. Also, indicate what
you've tried and why it hasn't worked-
Good Luck!
pim


--
Pim
------------------------------------------------------------------------
Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565
View this thread: http://www.excelforum.com/showthread...hreadid=470919