ESN conversion
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)
"jay-rod" wrote:
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!
|