NYCPHP Meetup

NYPHP.org

[nycphp-talk] Zip Code field in Excel

Michael Sims jellicle at gmail.com
Wed Nov 15 12:22:25 EST 2006


On Tuesday 14 November 2006 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?

Put a single quote in front of the value.  This value:

'01234

will be seen by Excel as the text string "01234" rather than the numeric 
value 1234.

(Another solution: the user can also, when importing into Excel, set that 
field as "Text" rather than "General".)

Michael Sims




More information about the talk mailing list