Hi Nelly, Have you looked into PEAR's Spreadsheet_Excel_Writer? I haven't used it myself, but perhaps you can have more control over cell types if you generate a native excel file rather than a csv file.
http://pear.php.net/package/Spreadsheet_Excel_Writer -- Dell On Nov 14, 2006, at 12:32 PM, Nelly Yusupova wrote: > 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
