LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 358
Default Excel 2003: date display issue

I saved data from a CVS file to Excel. I have a list of dates which display
as mm/dd/yyyy. However, when I try to sort the dates, they are organized by
month first, then day, then year as opposed to year, month, day, which is how
I would like it to sort the info.

I have another list of dates which is being read by Excel as dd/mm/yyyy but
in fact, the way it is organized, should be read as mm/dd/yyyy. So the
digits of 10/03/1962 should stay in the same order and be read as October 03,
1962. But Excel is reading it as March 10, 1962 because when I format the
date to m/dd/yy it reverses the 3 and the 10.

 
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
date in scatter chart excel 2003 dboudry Charts and Charting in Excel 1 March 16th 06 04:21 PM
In Excel 2003, I cannot display the toolbar with BOLD,UNDERLINE EJ Setting up and Configuration of Excel 2 March 15th 06 04:24 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2003: Not enough system resources to display completely Lady Layla Setting up and Configuration of Excel 12 October 14th 05 03:41 PM
Excel 2003 Inserting current date mark Excel Discussion (Misc queries) 3 February 9th 05 05:51 PM


All times are GMT +1. The time now is 04:44 PM.

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

About Us

"It's about Microsoft Excel"