|06-09-2011, 10:44 AM||#1|
Join Date: Aug 2010
Problem Creating Catalog of ISBNs
I apologize if this has already been addresses.
When exporting isbn the numbers changes. For example in calibre the isbn reads 9780758207012, however after I run the export it appears as 9.78076E+12 in the spread sheet. What am I doing wrong? I simply want to get a list of my isbns to paste them into google books.
I have read about a way to do this in calibredb command mentioned here http://www.mobileread.com/forums/showthread.php?t=67804
however I could not figure out how to do this.
|06-09-2011, 11:47 AM||#2|
Comparer of the Ephemeris
Join Date: Mar 2009
In your spreadsheet program, change the format of the ISBN column. For example, in Excel or Numbers, change the cell format to Number with 0 decimal places.
|08-09-2011, 05:35 PM||#4|
Join Date: Jun 2010
Device: Mobipocket reader on Blackberry, XO using FBreader, Kindle
Actually, you should probably use Text as the format in excel. Alot of 10 digit isbn's start with zero, which will get lost if you use a number format.
|08-09-2011, 06:44 PM||#5|
Well trained by Cats
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Astak Pocket Pro, K4NT,Galaxy Tab 2
BTW there are ISBN10's that end in 'X' (valid check digit 0-9,X)
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Error creating an epub catalog||pscynthetiq||Library Management||1||03-23-2011 06:52 AM|
|Conversion Error when creating Catalog||thangnh||Library Management||1||02-21-2011 08:38 AM|
|Problem with Catalog in Calibre||clockmaker||Library Management||1||10-05-2010 06:27 AM|
|Creating an online Stanza catalog||wdonne||News||6||02-25-2010 03:33 PM|