ESN conversion

[Guest]

Hi there, I tried searching and experimenting myself but I can't seem to find
a solution. I'm trying to figure out how to convert a cell phone ESN number
from HEX to DEC. The cell phone ESN's are unique in that they are 8
characters with the first two digits being a product code. Here is an example:

ESN HEX: 23 21 49 5F

The manufacturer code is 23 (hex) or 035 (dec)

The serial number is 21 49 5F (hex) or 02181471 (dec)

So the dec ESN is: 03502181471

So does anyone know how to make a formula that will convert it like that?
Thanks for your help in advance!

 

[Guest]

try ="0"&HEX2DEC(LEFT(A1,2))&"0"&HEX2DEC(RIGHT(A1,6)) with the hex code in
cell A1 with out spaces
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

Thank you John that works Perfectly!