First run a sort. Then create a second sorting column and stick an X where
it is numbers and leave it blank when you have letters. Or vice versa.

I think you have some cells stored as a number. Force them to text. Run a
sort and choose "Sort numbers and numbers stored as text separately".

"Jane Martin" wrote:

When I attempt to sort hex numbers in a spreadsheet I get incorrect results.
The cells are formatted as text (else the leading 0 would be dropped). I
would like sort results to run from 0000 - ffff. any ideas?