• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 37. Sorting Data > Sorting by Date and Time

Sorting by Date and Time

Excel sorts date fields using the serial number created by dates and times entered in cells. Sorting works correctly on only dates and times entered with a date and time format that Excel recognizes or created with date or time functions. If you enter dates and times that Excel does not recognize, Excel stores them as text and sorts them in text order, unless you use a special sorting order as described in the previous section.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint