I am working with numbers that contains an indisputable amount of digits, such as
social security numbers and others.
However, some of them starts with initial zeros. I am using the shown approach to ensure that Excel keeps the initial zeros (in datatables and Excel sheets), but when I use Lookup datatable (in Try Catch), sometimes (not regulary), the Lookup can’t find the number because of the initial zero, even if it looks right for the naked eye.
How can I ~ ensure ~ that the Lookup activity always get the right number of digits correct?