This document explains how to import the P8Auth subscriber report file into excel and reformat the username and SIM card number columns to show the full detail. 



Symptom: 


P8Auth report displays the username column and sim card columns in scientific notation. E.g. '8.932E+19'.  When changing the format of the cells to 'number', all SIM card cells are updated with an incorrect SIM number. See fig 1 for an example.


Fig: 1


Cause:


Upon opening the csv file, excel will display large numbers in scientific notation and truncate numbers larger than 15 digits. Any truncated digits will be replaced with a zero '0'.


Resolution:


To resolve this issue, follow the below steps to import the P8Auth Subscriber report into excel and update the SIM number cells to text format.


Note: The below instructions are based off of Office 365 and may vary from your version of excel. The principle however remains the same in terms of import and conversation of SIM numbers to text.


Step 1: Open a new excel spreadsheet


Step 2: Select 'Data' ->  'From Text'



Step 3: Select the P8Auth subscriber report to import into excel


Step 4: Select 'Delimited" as the data type and click next



Step 5: Select 'Tab' and 'Comma' as delimiters



Step 5: Set the SIM card column to 'Text' and click finish




Conclusion: The SIM card column should now be displayed correctly.