Forum Discussion

ssusin's avatar
ssusin
Regular Visitor
9 years ago

Missing ZIP Codes in Excel 3D Maps

In Excel 2016 3D maps, certain New York City ZIP codes are missing. Two examples are ZIP codes 10024 and 10014. That is, when I try to get these regions outlined, they appear blank, while most ZIP co...
Need Help
dh5237's avatar
dh5237
New Member
9 years ago

I'm having a problem with 3D Maps not finding a resolution for a set of several zip codes mainly the problem is with Zip Code with Leading Zero's  in Puerto Rico and the US Virgin Islands.  I 'm currently working on get the Lat and Lon data for my entire data set to hopefully eliminate the problem global . Overall I had a 95% Mapping Confidence for 13,051 unquie zip codes.  Any insights would be appreciated. 

Examples:

00603;00612;00659;00674;00680;00682;00692;00693;00694;00698;00716;00725;00729;00731;00732;00736;00738;00740;00757;00778;00784;00791;00802;00820;00840;00901;00907;00912;00917;00918;00926;00949;00957;00961;00962;00965;00966;00968;00976;00979;00982;00983;00987

 

 

Juppu's avatar
Juppu
Regular Visitor
9 years ago

Have you tried to format the zipcodes as text in the excel-sheet? it worked for me :)