How do you sort a column with Hexadecimal data

[lion99]

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

 

[Conan Kelly]

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

 

[ChristopherTri]

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...