Problem Creating Catalog of ISBNs

desilva · 06-09-2011, 10:44 AM

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 https://www.mobileread.com/forums/showthread.php?t=67804
however I could not figure out how to do this.

GRiker · 06-09-2011, 11:47 AM

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.

G

desilva · 06-09-2011, 02:48 PM

thanks!

TreborPugly · 08-09-2011, 05:35 PM

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.

theducks · 08-09-2011, 06:44 PM

Quote:

Originally Posted by desilva

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 https://www.mobileread.com/forums/showthread.php?t=67804
however I could not figure out how to do this.

ISBN are Always Text

besides your problem. Numbers will drop the leading Zero (ISBN10)
BTW there are ISBN10's that end in 'X' (valid check digit 0-9,X)

06-09-2011, 10:44 AM	#1
desilva Member Posts: 12 Karma: 10 Join Date: Aug 2010 Device: Kindle2	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 https://www.mobileread.com/forums/showthread.php?t=67804 however I could not figure out how to do this.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error creating an epub catalog	pscynthetiq	Library Management	2	09-30-2017 07:25 PM
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

06-09-2011, 11:47 AM	#2
GRiker Comparer of the Ephemeris Posts: 1,496 Karma: 424697 Join Date: Mar 2009 Device: iPad	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. G

06-09-2011, 02:48 PM	#3
desilva Member Posts: 12 Karma: 10 Join Date: Aug 2010 Device: Kindle2	thanks!

08-09-2011, 05:35 PM	#4
TreborPugly Member Posts: 13 Karma: 954 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.

Advert

Advert