User Tools

Site Tools


training:excel_import_leading_zeroes_2016

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
training:excel_import_leading_zeroes_2016 [2018/01/23 16:44 (6 years ago)] sjacksontraining:excel_import_leading_zeroes_2016 [2018/01/23 16:47 (6 years ago)] (current) sjackson
Line 1: Line 1:
 +====== Preventing Leading 0's From Being Dropped When Opening a CSV File in Excel 2016 or higher ======
 +
 All should know that a CSV file is never to be opened in Excel because Excel butchers the Part Numbers and Barcodes by stripping off the leading zeros from anything that looks like a number.  It also changes a perfectly good barcode into scientific notation like 1.2E+11, rendering it more than useless.  The only solution is to data load it into Excel if it needs to be edited, unless you edit it instead in Microsoft Notepad. All should know that a CSV file is never to be opened in Excel because Excel butchers the Part Numbers and Barcodes by stripping off the leading zeros from anything that looks like a number.  It also changes a perfectly good barcode into scientific notation like 1.2E+11, rendering it more than useless.  The only solution is to data load it into Excel if it needs to be edited, unless you edit it instead in Microsoft Notepad.
  
training/excel_import_leading_zeroes_2016.txt · Last modified: 2018/01/23 16:47 (6 years ago) by sjackson