Passa al contenuto principale
Supporto OCLC

Come posso impedire che gli zeri iniziali dei codici a barre vengano rimossi quando carico un CSV generato da WorldShare Reports in Excel?

Symptom
  • The leading zeros from item barcodes are stripped when I load a CSV generated by WorldShare Reports into Excel
Applies to
  • Report WorldShare
Resolution

To avoid leading zeros being stripped from item barcodes:

  1. Export the file from Report Designer in CSV format.
  2. Before importing into Excel, open a blank spreadsheet in Excel and format the column which will receive the item barcodes as a 'text' column.
  3. Load data from CSV file into the spreadsheet.
Additional information

This can also be applied to other fields which have leading zeros e.g. ISBNs.

Page ID
35446