Re: making leading zero's visible
From: Alan Little (alan_at_n-o-s-p-a-m-phorm.com)
Date: 05/11/04
- Next message: JE McGimpsey: "Re: Time Problem"
- Previous message: Hyun Yu: "Custom sort list question"
- In reply to: LRW: "making leading zero's visible"
- Next in thread: Doug Kanter: "Re: making leading zero's visible"
- Messages sorted by: [ date ] [ thread ]
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/
- Next message: JE McGimpsey: "Re: Time Problem"
- Previous message: Hyun Yu: "Custom sort list question"
- In reply to: LRW: "making leading zero's visible"
- Next in thread: Doug Kanter: "Re: making leading zero's visible"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
