Skip navigation

Date & Time cell sort

312 Views 5 Replies Latest reply: May 7, 2012 7:56 AM by Jerrold Green1 RSS
DMS808 Level 1 Level 1 (0 points)
Currently Being Moderated
May 5, 2012 3:15 PM

Im using Numbers '09 and trying to sort a Date & Time column in ascending order.  I dont want the date shown and have it set to None in the cell format tab in the inspector.  I have the time format set for 7:08 PM in the inspector.  When I select the column to do the sort, it seems to be sorting according to the date even though the date is set to None in the inspector, the Time is not in sorted in the full column, only by date.

 

How can I get the column to sort without / not using the Dates and only by the Time entered in the cell?  I dont want the Date listed, it is set to None.

 

The same thing is happening when I use the Numbers app on my iPad.

 

Can the Date column be sorted by Time only?

MacBook Pro, Mac OS X (10.7.2)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.