Changing Excel Numeric Values to Aleph System Numbers
- Leeda Adkins
- Heather Baker
Scope: Describes how to convert numeric values into Aleph system numbers in Excel.
Contact: Leeda Adkins
Unit: Metadata & Discovery Strategy Department
Date last reviewed: 12/14/2022
Date of next review: 12/14/2023
Aleph Services require system numbers to be 9 digits in length, with the Aleph Library appended to the end, example: 007741427DUK01
When the system number (Sysno) column is missing leading zeroes, create a blank column space beside the Sysno column, or alternatively copy the Sysno column into a blank Excel sheet. In the column beside the Sysno, enter the formula:
=TEXT(cellno, “000000000”) &”text to append”
EXAMPLE:
=TEXT(A2,"000000000") &"DUK01"
When the Sysno column has leading zeroes, in the column beside the Sysno column, enter the formula:
=cellno&”text to append”
EXAMPLE:
=A2&”DUK01”
To fill down, hover over the small green box in the bottom right corner of the adjusted cell until the cursor changes from a white plus to a dark +, then double-click. Copy the created system numbers into a text file to run with Aleph Services.