GeorgeGeorge
6 years agoQrew Cadet
Validate and fix US Zip code (5) if needed
I have a zip code field that may have more than or less than 5 characters.....I would like to create a text formula field that would Validate and fix my [Zip code (5)] field.
If the zip code is related to a [State] that has a leading zero at the beginning --- then I would like to add a leading zero if missing.....
Any advice or help is greatly appreciated
If the zip code is related to a [State] that has a leading zero at the beginning --- then I would like to add a leading zero if missing.....
Any advice or help is greatly appreciated