FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
zip code issues
#2
Hi got2web,

Interesting. Are you sure that the zero is missing in the database? It's very possible that it's being stored properly (in fact, my hunch is that it IS stored), but PHP and/or Excel is being "clever" and dropping it.

Adding an additional prefix, like a dot or an apostrophe might be the way to go (an apostrophe in a cell apparently tells Excel that the following content is text - so that may help). This would be done through the Export Manager's Excel export type; see this thread for more info:
http://forums.formtools.org/showthread.php?tid=503

Hope that helps a bit.

- Ben
Reply


Messages In This Thread
zip code issues - by got2web - Feb 24th, 2010, 9:29 AM
RE: zip code issues - by Ben - Feb 24th, 2010, 9:56 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)