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