On this page
Imports & validation
Keep leading zeros in ZIP codes and identifiers
Store identifiers as text in your spreadsheet so Excel does not remove zeros or change long values before import.
Updated
Prepare the cells before entering data
- In Excel, select the cells or column that will contain ZIP codes, Tax IDs or account identifiers. Set their number format to Text before typing or pasting the values.
- Copy the complete values from your authorized source. Keep any leading zeros and meaningful letters.
- Save the workbook. In the import preview, check the column mappings and sample values. After import, review the saved records before submitting an order.
If Excel already changed a value
Changing a cell to Text does not restore a digit Excel has already removed or rounded. Return to the original record and re-enter the complete value in a text-formatted cell. Do not guess missing digits.
A custom display format may make zeros appear on screen without changing the stored value. Check the actual cell value, not just how it looks. Long identifiers shown with an E or rounded digits need the same review.
Use the right format for each kind of field
This advice is for identifiers. Amounts, dates and checkbox fields have their own requirements in the current template. A foreign identifier may contain letters; do not strip them to make it resemble a domestic Tax ID.
If the forms are already imported
Do not upload another copy expecting it to overwrite the first import. Check the saved records and whether they have been submitted, then use the appropriate edit or correction process.