I have two Sharepoint Lists, one of which has a Primary ID field that is a Calculated Field that simply equals the Sharepoint generated ID field. Table 2 has a Lookup field that pulls in this new Primary ID. However, when it pulls in that number, it has ten trailing zeros. The field that is being looked up from Table 1 (and is a calculated field) is a Single Line of Text. Why is the lookup adding zeros to a text field and how do I get rid of them? I tried changing the format of the Calculated Primary ID field to Number and setting the decimal places to zero, however the Lookup no longer functions when I do that.