Import/export with leading zero

[Jay R. Ashworth]

On Mon, Feb 11, 2008 at 01:33:42PM -0500, Bruce Easton wrote:
> > When viewed with a text editor, the field is quoted "03001" but 
> > when opened, Excel drops the leading zero.
> > 
> > Any suggestions as to what I am doing wrong?
> 
> Richard - format the Excel column for that field to type text (and 
> alignment right if desired) prior to opening your file to load 
> into the spreadsheet.

In my response, which I think I dropped off-list, I missed the
direction of move: of course, it's excel configuration.  If you're just
trying to drop a CSV file, though, Richard, and open it raw with Excel,
you are going to have some trouble.

Is there a trick to force Excel to guess right for that column?

Cheers,
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274

	     Those who cast the vote decide nothing.
	     Those who count the vote decide everything.
	       -- (Joseph Stalin)