Occassional sorting hiccups & the number "40228"

Occassional sorting hiccups & the number "40228"

Sorting problems still occasionally occur.

I've been sorting strictly by column A (date), making sure that THE ENTIRE SHEET is selected ( I no longer trust the "expand selection?" option! )

I decided to sort by column D (last name). I selected entire sheet, and tried using "custom sort". It sorted that column, but the rows didn't follow along, as they should have. Fortunately, I was able to revert to an earlier version (the back-button wasn't 'active', so it wasn't an option).

ALSO-- I noticed something very peculiar (which also happened the last time I had a sorting problem): the number "40228" mysteriously appeared in a cell where there had before been data. This time, it appeared in column A/ row 1, instead of the word "DATE".

I deleted it, and retyped "DATE".

Last time I was having a sorting problem, this number arbitrarily showed up in a different cell, also in column A. I'm almost positive that it was the same number (40228) both times, that appeared. Has this problem been reported by others?