Morning,

Just a quickie (he says). Just tried to sort some data IE A1 = "Name", B1 = "Age", A2:A10 = Names, B2:B10 = Ages

Now, some of the "Ages" cells are blank.

I sorted the data by the Age column, smallest to largest and the blank cells went to the bottom of the list, as if being excluded by the function. How do I get excel to include the blank cells in the sort function and class them as a lesser value that any number (or letter should I ever have a blank cell in a text string column) so that the blanks show at the top?

I want my company to go back to '03 :-(