• Locate the CSV file in Windows Explorer and right-click it.
    • Select Rename from the menu

      Note: Do not open the CSV file in Excel before renaming it. Otherwise, the number will be rounded.. 

    • Change the extension from .CSV to .TXT
    • Open Excel
    • Select File, Open from the menu bar
    • Select the Delimited option and click Next
    • Unmark the Tab checkbox, mark the Comma checkbox, and click Next
    • Highlight the Import ID column and select Text as the Column data format
    • Click Finish. The file opens in Excel and does not change the last digit