| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Ron Rosenfeld wrote...
jay wrote... I Had A Row Of Hexadecimal Numbers I Want To Convert it to Decimal So I Used The Following Formula in the colloun On Cell # b2 =HEX2DEC(A2) Wher A2 Has The Hexadecimal Number And THe error I Get is #NUM Most likely, the number in A2 is not a valid hexadecimal number. What, exactly, is the contents of A2? In case either the hexadecimal number strings contain spaces or more than 10 characters, try this (assumes unsigned) =SUMPRODUCT(SEARCH(MID(RIGHT(REPT("0",32)&TRIM(A23 ),32), ROW(INDIRECT("1:32")),1),"0123456789ABCDEF")-1,16^(32-ROW(INDIRECT("1:32")))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Hybrid Mode
