How to fix truncated SKU numbers in Excel

Latest update: - Jack Harrison-Sherlock


To fix truncated sku numbers caused by Excel automatically formatting long strings of numbers to scientific notations and removing the leading 0.

If you use SKUs like 093986161536118, you will need to change the format of the SKU column when making edits.


  •  Excel for Mac or PC


  1. Highlight the SKU column
  2. Right Click > Format Cells
  3. Number > Decimal Place 0

Additional Information