| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you sort a column with Hexadecimal data
I need to sort hexadecimal data and have the results show the numbers from 0
to F. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you sort a column with Hexadecimal data
Try adding a column next to you Hex numbers using the HEX2DEC function to
convert them to decimal. You can then sort on the decimal column. Regards... "lion99" wrote: I need to sort hexadecimal data and have the results show the numbers from 0 to F. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable - Where have the units/records gone? | Excel Worksheet Functions | |||
| Sort does not recognize the header row | New Users to Excel | |||
| Macro question | Excel Worksheet Functions | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Linear Mode
