New numbers sort

W

wvtrammell


Joined
Jan 28, 2012
Messages
24
Reaction score
0
Points
1
With the latest numbers revision.
Sorting column b works
Sorting the same dates in column e fails.
Oct and Nov follow January and precede February
Any one else having this problem?
Thanks
Warren
 
M

MacInWin

Guest
Are they formatted as dates? If not, and they are just text, then 2 follows 1, which means that 1, 10, 11 and 12 will be in front of 2.
 
toMACsh

toMACsh


Joined
Jul 30, 2009
Messages
7,298
Reaction score
302
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
MacInWin said:
Are they formatted as dates? If not, and they are just text, then 2 follows 1, which means that 1, 10, 11 and 12 will be in front of 2.
Click to expand...

....that is, perhaps column B is formatted for dates and column E isn't
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top