training:excel_import_leading_zeroes_2016
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
training:excel_import_leading_zeroes_2016 [2018/01/23 16:44 (6 years ago)] – sjackson | training: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. | 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. | ||
training/excel_import_leading_zeroes_2016.txt · Last modified: 2018/01/23 16:47 (6 years ago) by sjackson