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