| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
CONVERT HEXADECIMAL CELL TO DECIMAL NUMBER
I USED THE HELP AND THE EXAMPLE BUT IT DIDN'T WORK, ANY HELP???
THE EXAMPLE IS GOOD IF I WANT TO PUT ONE NUMBER BUT NOT A CELL. I'M USEING OFFICE 2003 |
|
#2
|
|||
|
|||
|
Post your data and the formula you used.
-- HTH RP (remove nothere from the email address if mailing direct) "JAY" wrote in message ... I USED THE HELP AND THE EXAMPLE BUT IT DIDN'T WORK, ANY HELP??? THE EXAMPLE IS GOOD IF I WANT TO PUT ONE NUMBER BUT NOT A CELL. I'M USEING OFFICE 2003 |
|
#3
|
|||
|
|||
|
Dear Bob.
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 THanks For Ur replay jay "Bob Phillips" wrote: Post your data and the formula you used. -- HTH RP (remove nothere from the email address if mailing direct) "JAY" wrote in message ... I USED THE HELP AND THE EXAMPLE BUT IT DIDN'T WORK, ANY HELP??? THE EXAMPLE IS GOOD IF I WANT TO PUT ONE NUMBER BUT NOT A CELL. I'M USEING OFFICE 2003 |
|
#4
|
|||
|
|||
|
On Mon, 24 Jan 2005 17:37:02 -0800, jay wrote:
ear Bob. 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 THanks For Ur replay jay Most likely, the number in A2 is not a valid hexadecimal number. What, exactly, is the contents of A2? --ron |
|
#5
|
|||
|
|||
|
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
