View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default 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.