Re: making leading zero's visible

From: Alan Little (alan_at_n-o-s-p-a-m-phorm.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 10:35:16 -0500

Carved in mystic runes upon the very living rock, the last words of LRW of
comp.lang.php make plain:

> Anyway, I'm generating a text file, a CSV, that contains addresses
> from a database. Zip codes that have a leading zero (eg: 01234) has
> that 0 in the database, and it appears to have it when it's being
> inserted and written to the text file, but when you view it in Excel
> it goes away.

When importing, after you specify the delimiter, on the next screen select
all the fields and change the type to Text rather than General. You can
select all the fields at once. 

-- 
Alan Little
Phorm PHP Form Processor
http://www.phorm.com/
Loading