How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete
Pete, Electronic Engineer
Category: Consumer Electronics
Satisfied Customers: 16555
Experience:  Over 16 years of experience installing and repairing electronics.
30970729
Type Your Consumer Electronics Question Here...
Pete is online now
A new question is answered every 9 seconds

Is there an excel formula that can convert 15-digit IMEI

Customer Question

is there an excel formula that can convert 15-digit IMEI numbers to 18 Digit (IMEI) DEC numbers?
Submitted: 1 year ago.
Category: Consumer Electronics
Expert:  Pete replied 1 year ago.

Hi there,

You can use the following formula:

[{"success":true,"MEID_DEC":"270113181116019285","MEID_HEX":"A1000023F46F55","ESN_HEX":"805F9F78","ESN_DEC":"12806266744","METRO_SPC":"371290"},{"success":true,"MEID_DEC":"270113181116019286","MEID_HEX":"A1000023F46F56","ESN_HEX":"80015C64","ESN_DEC":"12800089188","METRO_SPC":"636565"},{"success":true,"MEID_DEC":"270113181116019287","MEID_HEX":"A1000023F46F57","ESN_HEX":"80AFB187","ESN_DEC":"12811514247","METRO_SPC":"973280"}]{"success":true,"MEID_DEC":"270113181116019287","MEID_HEX":"A1000023F46F57","ESN_HEX":"80AFB187","ESN_DEC":"12811514247","METRO_SPC":"973280"}

Customer: replied 1 year ago.
Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Help via Email or Text Message. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Expert:  Pete replied 1 year ago.
Hi,
I have sent you the offer you requested.

Related Consumer Electronics Questions