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.