Handling Telephone Numbers in Reports (Excel)
When Excel imports large numbers (International Telephone Numbers especially) it imports them in scientific Format. Local phone numbers are not sufficient long to trigger this Excel Inbuilt undesirable ‘feature’.
Further, TES generated Excel reports may strip off leading zeros from phone numbers when they are opened in Excel.
Click HERE to download the document for help