How do you sort a column with Hexadecimal data
 

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

How do you sort a column with Hexadecimal data
 

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




"lion99" wrote in message ...
I need to sort hexadecimal data and have the results show the numbers from 0
to F.

How do you sort a column with Hexadecimal data
 

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


"lion99" wrote:

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