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 revision Previous revision
training:excel_import_leading_zeroes_2016 [2018/01/23 16:44]
sjackson
training:excel_import_leading_zeroes_2016 [2018/01/23 16:47] (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 by sjackson