You have to make sure the zip code data is imported to Excel as text. By default Excel will treat is as a number and will therefore drop any leading zeroes.
Hope this helps ... -martin. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nelly Yusupova Sent: Tuesday, November 14, 2006 12:33 PM To: 'NYPHP Talk' Subject: [nyphp-talk] Zip Code field in Excel Hello Everyone, I wrote an application in PHP to export all of the data into a CSV document so my client can view the data. Everything works great except the Zip Code fields. For the zip codes that start with a zero, the zero is removed. I know this is done by Excel because it is treating the contents of the cell as a number. Is there any way to tell excel to treat the content of the cell as text automatically? Thank you in advance for your insights. Sincerely, Nelly Yusupova http://www.digitalwoman.com _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
