NYCPHP Meetup

NYPHP.org

[nycphp-talk] Zip Code field in Excel

Martin Lanser redbox2000 at optonline.net
Wed Nov 15 16:11:43 EST 2006


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: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Martin Lanser
Sent: Wednesday, November 15, 2006 4:05 PM
To: 'NYPHP Talk'
Subject: Re: [nycphp-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: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Nelly Yusupova
Sent: Tuesday, November 14, 2006 12:33 PM
To: 'NYPHP Talk'
Subject: [nycphp-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




More information about the talk mailing list