If I sort a column of numbers all is well but not when I have a column of text.
I have a column of text that looks like this (note I type a column of text below but it displays as a line of text???)
ZZZ
DDD
BBB
If I choose Data > Sort > Ascending the column is sorted EXCEPT that the first cell is not included and remains unchanged, resulting in:
ZZZ
BBB
DDD
How can I force the first cell to be included in the sort?