Saturday, February 16, 2019

Leading Zeroes on Zip Codes are removed when search results are exported to CSV

The leading zeroes or Zip Codes are removed when search result is exported to CSV. The leading zeroes will be visible if you open the file on a Notepad. Leading zeros are no longer visible on the CSV file because CSV treats the value as a number. To fix this:

 

1. In the exported CSV file, select the Zip Code column.

2. Right click.

3. Choose Format Cells.

4. On the Numbers tab, select Special and set Type to Zip Code.

5. Hit OK.

 

Note: The leading zeroes will be intact if the search is exported to Excel.

 

No comments:

Post a Comment