Zip codes xlsx to ArcGIS Pro and data population

[chagithebear]

Hi all. I am bit in a pickle. I have a xlsx file that contains the zip code starting with the number 0, formatted as zip code in each cell. However, when I import the xlsx file onto ArcGIS Pro the attribute table populates the table without the '0' as the starting digit. Is there a way for ArcGIS to recognize the starting '0' in the zip code? 

Additionally, once I have the zipcode in place. How do I populate my attribute table to the map? Please see example below. 

Thank you all for your help! 

county	agecat	rate	er1719	pop1719	county code	FIPS code
Alameda	1-2 years	277.1	343	123793.9	01	06001
Alameda	10-13 years	138.7	323	232862.8	01	06001
Alameda	14-17 years	183.5	423	230547.5	01	06001
Alameda	18-34 years	559.5	6149	1.1E+10	01	06001
Alameda	3-5 years	293.9	541	184077.8	01	06001
Alameda	35-64 years	366.6	7172	1956263	01	06001
Alameda	6-9 years	268.9	620	230542.2	01	06001
Alameda	65-100 years	211.7	1442	681063.4	01	06001
Alameda	<1 year	183.4	114	62147.6	01	06001
Alameda	All ages	356.8	17127	4800400	01	06001
Alpine	1-2 years	0	0	51.5	02	06002

[JoshSaad1]

I'm not sure if this will work necessarily, but you could try formatting your data in Excel as a table, and specifying the data type for the zip code column explicitly as Text instead of a number, and then importing it into ArcGIS Pro.

Alternatively, you could add a letter to each field, import it into GIS, and then remove the letter using Calculate Field.