Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel date format issue

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 380
Default Excel date format issue

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: date display issue Andrew Excel Discussion (Misc queries) 17 July 13th 06 05:36 PM
Date format issue CindyLF1 New Users to Excel 3 June 12th 06 06:18 PM
Excel default date format mjk Excel Discussion (Misc queries) 1 August 16th 05 10:52 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel enters date as a text format Kane Excel Discussion (Misc queries) 3 March 22nd 05 10:20 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"