Hi, someone sent me an excel file with the date field format *3/14/2001. She
is using XP, and on her screen, the date Oct 5, 2006 was displayed as
10/5/2006. However, when I opened the file in Excel 2003 (Windows 2000), the
date was displayed as 5/10/2006. I interpreted the date as May 10, 2006.
Another cowork who uses XP opened the same file was able to see the date as
10/5/2006.
What should we do so we all see the date displays as mm/dd/yyyy? Your help
is much appreciated.

Check your regional settings in the control panel, looks like it is a non-US
format.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"rs-excel" wrote in message
...
Hi, someone sent me an excel file with the date field format *3/14/2001.
She
is using XP, and on her screen, the date Oct 5, 2006 was displayed as
10/5/2006. However, when I opened the file in Excel 2003 (Windows 2000),
the
date was displayed as 5/10/2006. I interpreted the date as May 10, 2006.
Another cowork who uses XP opened the same file was able to see the date
as
10/5/2006.
What should we do so we all see the date displays as mm/dd/yyyy? Your help
is much appreciated.