How do I sort hexidecimal numbers in an excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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".
 
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)
 
Back
Top