My UPCs are saving with multiple 0’s (Scientific notation format)?

This results from your spreadsheet software automatically recognizing the UPCs as a long number. Thus, it saves it in scientific notation.

Example: 12345678901 shows as 1.23E+10

To fix this, you can either:

Select the cells with scientific notation, right-click->Format Cells->Select Text and click “OK”

  • 1.png
  • 2.png

You can also highlight the UPC column, and then select “General” from the format box dropdown on the “Home” tab of Excel:

  • 3.png
  • 4.png

 

Here are some additional articles you may find useful:

UPCs for Handmade Products

Saving & Validating UPCs

 

Was this article helpful?
0 out of 0 found this helpful
Still have questions? Chat Us or Submit Help Request