Importing .xlsx file which has 1,977 12-digit APN data into ArcGIS Pro results in the 12-digit APN data being truncated, and leading/ending zeros are removed.

This also occurs if i convert the .xlsx file into a .csv file, and import it into ArcGIS Pro, it also truncates the 12-digit APN number and removes the leading/ending zeros.

How can I import either a .xlsx or .csv into ArcGIS Pro without the data being truncated??

Any help would be appreciated...

Thank you in advance.

Fixing the excel sheet would be easiest

in cell C2, put in the above formula and copy it down the column

In cell C1... Give it a name like Parcel_txt

Or just do it in Pro using a field calculator function.... easy as 1, 2, 3