I'm about to start working on the side doing some basic updating of ISBN's on a management site. I'm trying to hash out the issues I may encounter before I give a definite yes since it's family that I'll be working before. Here is my potential issue:
Say you have these two numbers:
1.) 0012345678
2.) 0000023456789
I know the way to format it so that the two zero's appear in front on a 10 digit number but what about when you would have 10 and 13 number ISBN's in the same excel sheet? If I were to do this:
1. Right-Click-> Format Cells
2.) Custom-> Type-> 0000000000
That would take care of any 10 digit numbers but it would make the 13 digit number lose some of the zero's.
Any ideas? I am not an Excel expert because I deal more with general repairs and deployments.
Thanks!!!
Say you have these two numbers:
1.) 0012345678
2.) 0000023456789
I know the way to format it so that the two zero's appear in front on a 10 digit number but what about when you would have 10 and 13 number ISBN's in the same excel sheet? If I were to do this:
1. Right-Click-> Format Cells
2.) Custom-> Type-> 0000000000
That would take care of any 10 digit numbers but it would make the 13 digit number lose some of the zero's.
Any ideas? I am not an Excel expert because I deal more with general repairs and deployments.
Thanks!!!