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! |
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! |
ESN conversion
Thank you John that works Perfectly!
|
All times are GMT +1. The time now is 11:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com