How Can We Help You?

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:

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

1.png

2.png

 

   2. 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?