Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ESN conversion
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ESN conversion
Thank you John that works Perfectly!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Discussion (Misc queries) | |||
Conversion | Excel Discussion (Misc queries) | |||
pdf conversion | Excel Worksheet Functions | |||
Between conversion | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |