Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    16 or 17 digit SFX object ID not imported into excel correctly

    • Product: SFX
    • Product Version: 4
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, 

     

    Problem

    There is a known issue in Excel with numbers with over 15 digits.

    The last digit of some SFX object IDs may be converted into a 0, if the ID number is greater than 15 digits. 

    Solution

    Import the cells in the object_ID column in "Text" format instead of "General" or "Number" format.

    As "Text" format, the object IDs should be accurate. 


    Additional Information

    See Microsoft Knowledge Base:

    http://answers.microsoft.com/en-us/o...0236bd0?auth=1

     


    • Article last edited: 03-Aug-2016
    //doorbell.io feedback widged