NYCPHP Meetup

NYPHP.org

[nycphp-talk] Zip Code field in Excel

Nelly Yusupova nelly at cgim.com
Tue Nov 14 12:32:55 EST 2006


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




More information about the talk mailing list