Formatting Zip Codes
Posted: Wed May 18, 2011 11:38 am
Hi Guys,
I'm having a hard time figuring out how to format proper zip codes.
The field in the DataBand looks like this:
Which displays results in this format:
I need it to format this zip code like this:
I tried to edit it by clicking Text Format, selecting Custom, and typing #####-#### and it still excludes the hyphen. Do you guys have a quick fix to this?
Thanks!
I'm having a hard time figuring out how to format proper zip codes.
The field in the DataBand looks like this:
Code: Select all
{QueryResults.Customer_Zip}
Code: Select all
000000000
Code: Select all
00000-0000
I tried to edit it by clicking Text Format, selecting Custom, and typing #####-#### and it still excludes the hyphen. Do you guys have a quick fix to this?
Thanks!