I just reread your question. Yes, in an Excel cell you can put a single quote in front of something and it is then treated as text, but I don't know if that works in a CSV file.
Sorry for any confusion. -martin. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Lanser Sent: Wednesday, November 15, 2006 4:05 PM To: 'NYPHP Talk' Subject: Re: [nyphp-talk] Zip Code field in Excel 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 _______________________________________________ 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
