Admins: To correct the display of ISBN numbers that are showing in Excel as 9.78E+12

When a file with ISBN numbers is opened in Excel, it may default to showing the ISBN numbers in “scientific notation”.  This is just a display issue.

To make ISBN numbers display correctly:

  1. Highlight the column or columns
  2. Set the type to “Number” (instead of “General”)
  3. It automatically adds two decimal place zeros that you need to get rid of:
    Click the icon of  “.00 to .0″
    Click it again
  4. The ISBN numbers should now be showing as long numbers.