Troubleshooting
      Back to home
      1. PrologMobile Knowledge Base and FAQ
      2. Troubleshooting

      How to format IMEIs in excel and csv files from PrologMobile's UI

      Excel converts the IMEIs into a truncated version, which you may need to correct

      1. If you export directly to excel, it shouldn't convert the format. 
      2. If you export to CSV, the format gets converted, in order to fix this, you must follow these steps.
        1. Highlight the columns in questions
        2. Click this dropdown: 


        3.  
        4. Select the bottom option "more number formats"/



        6. highlight the text box


          type in hash-tag and 14 zeros
        7. "#00000000000000"
        8. This should fix it. 
       
      Once you have saved the file without converting properly, the data is lost, as is the case in your example. You need to redownload the file and save it with the correct data, otherwise excel automatically converts it, which we cannot control.