I have a database some 10 columns wide and 1200 rows deep. When I sort by
one particular column it sorts BLANKS before text meaning that the data
appears at the bottom of the database although still in alphabetical order.

I have the formatting set to GENERAL for the whole column and do want the
blank cells. None of the other columns do this. I am totally perplexed as I
thought Excel sorted blanks nearer the end of it's priority.

I have tried formatting the column to TEXT and even NUMBER also but it still
makes the data appear at the bottom of the table. This doesn't make any
sense to me...HELP,

Thanks for any help in advance.

Robbie