Forum Discussion
Managing changes in Office 365: An overview of resources
Is there a formula to change a 10 digit ISBN into a 13 digit ISBN
eg
| 1845506820 | 9781845506827 |
6 Replies
- My answer is no. Formula may be used only to add a check digit at the end of ISBN. The same is true for GTINs.
Twifoo , just for my interest, what is calculating here http://useroffline.blogspot.com/2008/08/tip-spreadsheet-conversion-for-isbn-10.html then?
- ISBNs are assigned, not simply converted. For editions published before the year 2007, 10 digits are assigned, including the check digit which is the 10th.
Conversely, 13 digits are assigned for editions published starting in the year 2007. The 13th digit is the check digit.
GS1 allocates the prefixes 978-979 for editions published starting in year 2007. To legally convert 10-digit ISBN to 13-digit ISBN, a revised edition, not simply a reprint, thereof must be published starting in the year 2007.
The publisher applies for ISBN, which may have a prefix of either 978 or 979, starting in the year 2007.
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
