On the dropdown grid, I'm trying to format the U.S. postal code when displayed. I'm using *5{#}[-*4#] as the display format but nothing appears in the postal code column. What format should I use that will display either the full 9 digit postal code (zipcode) if it exists or just the first 5 digits if it doesn't?
thank you
I want the hyphen after the 5th digit for a cleaner display. I'll check out the displayformat
thanks