Thursday, June 23, 2011

yogi_Sort HEX Numbers Listed In A Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Amanitas said:
How do I sort numerically when using Hexadecimal values?
I have a list on numbers, all of which are Hex. how am I able to sort this column?
----------------------------------------------------------------------
The SORT functions is based on sorting decimlal (base 10) numbers ... so I will use this aspect to sort the column of HEX numbers.