Numbers, Text, Dates, and Sorting in Calc
I ran into a problem with the formatting in cells today for sorting. I was trying to sort a number of dates, and they kept sorting as strings. I set the format of the cells to the appropriate date format, made sure all the cells were showing up that way, and tried the sort again….