ZipCodes

[FM NewB]

My question is when zip codes are entered with 5 numbers and then the new 4 numbers but wihtout the hypen is there anything you can do to automatically enter the hypen without going through all the data? I am self teaching, new and getting frustrated. ex:48825-4801 (?)

Thank you

[BobWeaver]

You can use this formula to check for and insert the hyphen:

Case(Length(ZipCode)>5 and PatternCount(ZipCode,"-")=0,

Left(ZipCode,5) & "-" & Middle(ZipCode,6,4),

ZipCode)

You can either use this formula in a new calculated formatted zip code field, or as the formula in a replace command to replace the original data in the same field. If you are going to directly change the original data, make sure you back up your file first.