Skip to content
English
  • There are no suggestions because the search field is empty.

File Dropping Leading Zeroes

  1. Open CSV file in Excel

  2. Highlight the ISBN column to select all

  3. Right click and use Format Cells

  4. Select category Custom

  5. In Type enter 10 0's, 0000000000, then OK.

  6. That will have the leading 0's there. 

  7. This may need to be "Save As" a type .xlsx in order to hold onto that formtating.