You need to sign in to do that
Don't have an account?

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
wrote formula field: " ' " & Zip_code__c
by using this leading 'zeros' coming but ' special character also appearing before leading zero in csv file
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.