zip code cutting off the first zeros
My zip code field is removing the first two zeros for New England states.
Don't have an idea what I am doing.
Any help appreciated.
Zip code that is number field will truncate leading zeros
Zip code that is text field will not.
IMHO - It's a number, leave it a number.
calculated field - if length(zip) = 4; 0 & Zip; Zip
This works. Thank you.
Retrieving data ...