Apr 23 2019 08:46 AM
Is there a formula to change a 10 digit ISBN into a 13 digit ISBN
eg
1845506820 | 9781845506827 |
Apr 23 2019 09:40 AM
@GW_excel1935 , you may check http://drziegler.net/generating-eanisbn-13-check-digits-in-excel/ or http://useroffline.blogspot.com/2008/08/tip-spreadsheet-conversion-for-isbn-10.html and I believe there are more samples
Apr 23 2019 02:53 PM
Apr 23 2019 03:09 PM
@Twifoo , just for my interest, what is calculating here http://useroffline.blogspot.com/2008/08/tip-spreadsheet-conversion-for-isbn-10.html then?
Apr 23 2019 04:03 PM
Apr 23 2019 04:20 PM
@Twifoo , so all this bunch of ISBN10=>13 converters on the web (not only Excel formulas) are just "faking" info and we shall ignore them? My understandig was what for existing before 2007 publications not totally new ISBN13 assigned, but converted by some algorithm from ISDN10.
It looks like I was wrong.
Apr 23 2019 05:01 PM