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?