| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can I use HEX2DEC with cell references vs. numbers?
I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC
function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. |
|
#2
|
|||
|
|||
|
Would it be something other than =HEX2DEC(A1)? That should convert the
hexadecimal value located in the cell A1 to decimal value. I'm not quite sure what you mean if it's something other than that. But it should work to just put in the cell reference. -- Regards, Dave "cjssas" wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. |
|
#3
|
|||
|
|||
|
Dave,
You are absolutely correct. I just tried some dummy data & it worked. My intial problem seemed to be that the numbers I tried to convert had leading characters (i.e., 0x004803) that the function did not seem to like. I'll just have to only copy the characters I need and leave out the leading 0x00 stuff. Still pretty manual but at least the function works. Thanks for your help. "David Billigmeier" wrote: Would it be something other than =HEX2DEC(A1)? That should convert the hexadecimal value located in the cell A1 to decimal value. I'm not quite sure what you mean if it's something other than that. But it should work to just put in the cell reference. -- Regards, Dave "cjssas" wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. |
|
#4
|
|||
|
|||
|
Cool.
An easy way to get that x out, would be go to Data-Text to Columns, choose delimited, and select the "Other" box and type in "x" for the delimiter. -- Regards, Dave "cjssas" wrote: Dave, You are absolutely correct. I just tried some dummy data & it worked. My intial problem seemed to be that the numbers I tried to convert had leading characters (i.e., 0x004803) that the function did not seem to like. I'll just have to only copy the characters I need and leave out the leading 0x00 stuff. Still pretty manual but at least the function works. Thanks for your help. "David Billigmeier" wrote: Would it be something other than =HEX2DEC(A1)? That should convert the hexadecimal value located in the cell A1 to decimal value. I'm not quite sure what you mean if it's something other than that. But it should work to just put in the cell reference. -- Regards, Dave "cjssas" wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. |
|
#5
|
|||
|
|||
|
Dave,
Whoo Hoo! You da man! Thanks very much. "David Billigmeier" wrote: Cool. An easy way to get that x out, would be go to Data-Text to Columns, choose delimited, and select the "Other" box and type in "x" for the delimiter. -- Regards, Dave "cjssas" wrote: Dave, You are absolutely correct. I just tried some dummy data & it worked. My intial problem seemed to be that the numbers I tried to convert had leading characters (i.e., 0x004803) that the function did not seem to like. I'll just have to only copy the characters I need and leave out the leading 0x00 stuff. Still pretty manual but at least the function works. Thanks for your help. "David Billigmeier" wrote: Would it be something other than =HEX2DEC(A1)? That should convert the hexadecimal value located in the cell A1 to decimal value. I'm not quite sure what you mean if it's something other than that. But it should work to just put in the cell reference. -- Regards, Dave "cjssas" wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. |
|
#6
|
|||
|
|||
|
On Fri, 2 Sep 2005 12:27:03 -0700, cjssas
wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. =HEX2DEC(A1) works fine here, with a HEX number in A1. What, exactly, are you doing? --ron |
|
#7
|
|||
|
|||
|
Ron,
I'm trying to convert some hex numbers that are in a text file to decimal. I have been copying the text out of the text file & pasting it into an Excel spreadsheet. The format of the hex numbers includes leading 0x0 in front of the hex numbers. The function did not seem to work w/ the leading characters. "Ron Rosenfeld" wrote: On Fri, 2 Sep 2005 12:27:03 -0700, cjssas wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. =HEX2DEC(A1) works fine here, with a HEX number in A1. What, exactly, are you doing? --ron |
|
#8
|
|||
|
|||
|
Well, if they all have the leading 0x0 you could use:
=hex2dec(MID(A1,FIND("x",A1)+1,255)) On Fri, 2 Sep 2005 12:54:02 -0700, cjssas wrote: Ron, I'm trying to convert some hex numbers that are in a text file to decimal. I have been copying the text out of the text file & pasting it into an Excel spreadsheet. The format of the hex numbers includes leading 0x0 in front of the hex numbers. The function did not seem to work w/ the leading characters. "Ron Rosenfeld" wrote: On Fri, 2 Sep 2005 12:27:03 -0700, cjssas wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. =HEX2DEC(A1) works fine here, with a HEX number in A1. What, exactly, are you doing? --ron --ron |
|
#9
|
|||
|
|||
|
Ron,
Thanks for your help. Your formula seems to work better. "Ron Rosenfeld" wrote: Well, if they all have the leading 0x0 you could use: =hex2dec(MID(A1,FIND("x",A1)+1,255)) On Fri, 2 Sep 2005 12:54:02 -0700, cjssas wrote: Ron, I'm trying to convert some hex numbers that are in a text file to decimal. I have been copying the text out of the text file & pasting it into an Excel spreadsheet. The format of the hex numbers includes leading 0x0 in front of the hex numbers. The function did not seem to work w/ the leading characters. "Ron Rosenfeld" wrote: On Fri, 2 Sep 2005 12:27:03 -0700, cjssas wrote: I want to use HEX2DEC to convert hex numbers to decimal. The HEX2DEC function seems to only work with number. If I can use the function on a number by referencing it's cell then I could convert a large number of hex numbers to decimal. =HEX2DEC(A1) works fine here, with a HEX number in A1. What, exactly, are you doing? --ron --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
