Print
Category: Manage in the Office

If you download the TCTrak Log, you may notice that Excel is converting the Batch and Parent Batch ID's to scientific notation. In order to avoid this do one of the following.

OPTION 1. Download the TCTrak Log, DO NOT open the CSV download file in Excel, save the file onto your computer and do a direct import of this CSV file into your other software package to avoid Excel converting the format.

OPTION 2:

  1. Open Excel
  2. Click "Data" tab
  3. Click "Open Text/CSV"
  4. Select CSV File --> "Import"
  5. Under Data Detection menu --> "Do not detect data type"
  6. Click "Load"
  7. Remove formatting (optional, uncheck "Header Row" and "Banded Row" boxes)