Skip to content
  • There are no suggestions because the search field is empty.

Prevent Excel from Using Scientific Notation Format for CSV Import Files

This article walks through how to prevent scientific notation formats from modifying data.

  1. Open an Excel worksheet.
  2. Select the Data tab.
  3. Click the From Text option.
    U7oTpKRSGsT0bXjsMjhg9w9Oki7YUb_9MQ
  4. Use the Windows Explorer window that appears to select the .csv file with your employee or visitor data.
  5. Select " Delimited" then click Next.QsHVPpGgED0IcMXtRQcsxdz7Bdtk92Kdzw
  6. Check the "Comma" then click Next.7XMTdnTEsdFQ9LjV42B2WTmyBa2Vmex-cg
  7. Select the "Text" option and click Finish.Gk3LagHoL6w-FcaveYmQQCwBkrJnVZJnCw-1
  8. Ensure the "Existing worksheet" is selected, and then click OK.
  9. Under File, select Save As.
  10. Select .csv from the "Save as type" list.
  11. Upload your CSV file to the ALICE portal.