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