Hi,
I have file that is importing social security numbers to access. It is coming in aas a text.However dropping a zero if it has a zero in front of it - for example "012345678" is coming through as "12345678". Is there a way I can update the socials with the zeroes in front?

Thanks in advance,
Payal

It should not drop the zero if the field type is set as Text in the destination.

If there are always nine characters you can format with this:
Format([fieldname], "000000000")