Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date in scatter chart excel 2003 | Charts and Charting in Excel | |||
In Excel 2003, I cannot display the toolbar with BOLD,UNDERLINE | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2003: Not enough system resources to display completely | Setting up and Configuration of Excel | |||
Excel 2003 Inserting current date | Excel Discussion (Misc queries) |