3 ms·
Fun thing I noticed is converting a CSV to XLSX in Excel also drops leading 0s from zip codes...
by lubujackson 1y ago
Fun thing I noticed is converting a CSV to XLSX in Excel also drops leading 0s from zip codes...
- fuzzy_biscuit 1y agoMost spreadsheet software does that because the zips are parsed as integers, not strings . Prefix numerical fields that may contain leading zeros with a non-numerical character/word and save yourself the pain of late discovery! You can just find and replace after it goes in successfully. Spoken as someone that experienced the same pain years ago in local SEO data that made it way too far before discovery...
- layer8 1y agoYou need to select the correct column data format in the Text Import Wizard: https://filestore.community.support.microsoft.com/api/images/c90489ae-ca9e-4140-8848-b11d47adb505 https://filestore.community.support.microsoft.com/api/images...