Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. 16 or 17 digit SFX object ID not imported into excel correctly

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Problem
    2. Solution
    3. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • “back” radio button at the bottom of the list of targets is inactive
      • 856_URL target description
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. excel
      2. export
      3. object_id
      4. sfx
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved