When I ran a sort on those kinds of strings, the data was sorted ok.

But if you're having trouble, you could use a helper column and a formula:

=hex2dec(a1)
and drag down

Then sort your data based on this key.

====
I did format all the cells as text--including those that looked like:
1234 (4 numbers)


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?

--

Dave Peterson