How do you sort a column with Hexadecimal data

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

Guest

I need to sort hexadecimal data and have the results show the numbers from 0
to F.
 
lion99,

You might need another column. You may need to enter numbers in decimal format and convert them to hex, or enter them as hex and
convert them to decimal; and then sort on the decimal column. Check out the functions DEC2HEX, HEX2DEC, DEC2BIN, BIN2DEC, etc... in
Excel's Help files.

I hope this helps,

Conan Kelly
 
Try adding a column next to you Hex numbers using the HEX2DEC function to
convert them to decimal. You can then sort on the decimal column.

Regards...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hexadecimal data 2
How can I automatically decrement a column in hexadecimal numbers 4
Hexadecimal to binary 5
in excel, how to limit digits of negative hexadecimal numbers? 1
Can Excel convert from hex to decimal and vice versa? 2
Convert IP Address to a hexadecimal 2
How do I represent data in a cell as hexadecimal without converti. 1
Hexadecimal to Binary 11

Back
Top