NYCPHP Meetup

[Sean Pangia]

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: 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
> 

-- 

   _______________________________________
   Sean Pangia

   Red Cent
   54 West 21st Street, #607
   NYC 10010

   212.255.3800 ext. 201
   www.redcent.net