NYCPHP Meetup

[Donald J Organ IV]

it will work when displaying a CSV file in excel, but now the data has a 
single quote in it.

Martin Lanser wrote:
> 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
>
> _______________________________________________
> 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
>
>
>