Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates in format "01/19/09"
How do I set my Excel to Always sort dates in the following format by Year,
Month, and Day? My current setting sorts by Month, date, and then year. For example my setting is sorting as follows: 01/19/09 02/01/08 02/17/08 etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates in format "01/19/09"
By the looks of it, you're sorting as text, rather than dates. What
do=ISTEXT(cellref) and =ISNUMBER(cellref) give you for a typical cell in your range? If you've got text, you'll need to change to dates before sorting. -- David Biddulph "SCH" wrote in message ... How do I set my Excel to Always sort dates in the following format by Year, Month, and Day? My current setting sorts by Month, date, and then year. For example my setting is sorting as follows: 01/19/09 02/01/08 02/17/08 etc. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates in format "01/19/09"
Hello SCH,
dates are numbers in excel and it does not deppend the format you use, it looks you are working with text, instead of date, if my understand is wrong, and you have dates as dates not as text, you just need sort descending hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "SCH" escreveu: How do I set my Excel to Always sort dates in the following format by Year, Month, and Day? My current setting sorts by Month, date, and then year. For example my setting is sorting as follows: 01/19/09 02/01/08 02/17/08 etc. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates in format "01/19/09"
If the dates are set as text, you may see green triangles on the top of the
cells. Highlight all of them, click on the yellow exlamation point that appears, and perform you correction there. "Marcelo" wrote: Hello SCH, dates are numbers in excel and it does not deppend the format you use, it looks you are working with text, instead of date, if my understand is wrong, and you have dates as dates not as text, you just need sort descending hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "SCH" escreveu: How do I set my Excel to Always sort dates in the following format by Year, Month, and Day? My current setting sorts by Month, date, and then year. For example my setting is sorting as follows: 01/19/09 02/01/08 02/17/08 etc. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates in format "01/19/09"
On Wed, 13 May 2009 09:48:08 -0700, SCH wrote:
How do I set my Excel to Always sort dates in the following format by Year, Month, and Day? My current setting sorts by Month, date, and then year. For example my setting is sorting as follows: 01/19/09 02/01/08 02/17/08 etc. Most likely your data is stored as TEXT rather than as dates. To prove this, =ISNUMBER(cell_ref) will give FALSE (if they are stored as dates it should return TRUE). To correct this, you can try: select a blank cell edit/copy select your range of dates edit/paste_special/add The values may change to 5 digit numbers. Just select to format them as dates. Now they should sort. If this does not work, there may be extra characters within the cell. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to ignore "a", "an", "the" when sorting? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
Stop autoformatted dates without using "format TEXT" or ' | Excel Discussion (Misc queries) | |||
How do I count like dates in a column with format "January-05"? | Excel Worksheet Functions |