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