Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Abhirams470Abhirams470 

leading "zeros" are eliminationg in zip code when export to csv file.

leading "zeros" are eliminationg in zip code when export to csv file.

wrote formula field: " ' "  & Zip_code__c

by using this leading 'zeros' coming but  ' special character also appearing before leading zero in csv file

crop1645v2crop1645v2
First of all, check to see that the real csv file is missing the leading zero (that is, examine in Notepad or equivalent, not in Excel). I suspect it is actually there. Excel thinks it is a number and thus strips the leading zero.

If the output is going into Excel for further manipulation, make the zip code look like a 9 digit zip code as follows:

Workaround is to append '-' to any US zipcode with a leading 0. E.g. 01234 converted to 01234- as the latter is a valid postalcode and excel csv wont lose the leading zero.