G
Guest
How do you prevent the leading zero (in zip codes) from dropping? I am
trying to create a table w/ various zip codes.
trying to create a table w/ various zip codes.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
kerry_ja
Have the zip code as text, not a number
W
Wayne Morgan
The easiest way is by making the field a text field instead of a number
field.
field.
J
Joseph Meehan
ltc said:How do you prevent the leading zero (in zip codes) from dropping? I
am trying to create a table w/ various zip codes.
Use number only when you need to use them in calculations or to sort
them when there may not be leading zeros with the same total number of
characters.
Since zip codes are not calculated, then you will want to use a text
type. If you want to sort them, be sure to include zeros for the plus 4
part as well.
G
Guest
Best practices show that Zipcodes are actually Text Fields, Take Canada's
Postal Codes, they have a combination of Numeric and Alpha, which constitutes
it as a Text Filed.
Postal Codes, they have a combination of Numeric and Alpha, which constitutes
it as a Text Filed.