View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
one idea (not tested though) use in a helper column the formula
=HEX2DEC(A1)
copy this for all rows and sort with this column

Note: You need to install the Analysis Toolpak Addin for this

--
Regards
Frank Kabel
Frankfurt, Germany

"BobD" schrieb im Newsbeitrag
...
How do you sort a column of data that is in hexidecimal? I sort by

column and
it scrambles because it is in hex.
Thak you.