you can also do a Format Cell > Number > Special > Zip Code
Martin Lanser wrote: > 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 > -- _______________________________________ Sean Pangia Red Cent 54 West 21st Street, #607 NYC 10010 212.255.3800 ext. 201 www.redcent.net _______________________________________________ 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
