converting phone hex to dec in excel

[Jeff]

I need to convert hex serial numbers to dec in excel. The
challenge for me is breaking apart the numbers. An 8
digit hex 9f6cf640 is broken into 9f = 159, and 6cf521 =
7140928 for a dec of 15907140928. Once the numbers are
broken apart and converted they must be connected again,
and the back half must be lengthened to 8 digits. The two
digit front half of the hex also must be lengthened in
some cases by also placing a 0 on the front.

Does anyone know of a formula or macro to do this that
will work that will work in excel?

Thanks!

 

[acw]

Jeff

Assuming that the number you want to convert is in A1, then
=hex2dec(LEFT(A1,2))&0&hex2dec(RIGHT(A1,6))
should give you what you are chasing.


Tony

 

[Biff]

Hi Jeff,

If you have the Analysis ToolPak add-in installed, use the
HEX2DEC function. When you say the back half has to be
lengthed to 8 digits, how? By adding zero's? And on which
end? Same thing for the front 2 digits - must be lengthed
in some cases? Can you be more specific?

Biff