Feb 24th, 2010, 9:56 PM
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
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