[Download-List] Download Excel format

[Jacob Geluk]

Jason Wininger wrote:

> Is there a way to download and get the leading zeros in fields to 
> remain when naming the file with a .csv extension for Excel?  I know I 
> can run it through the wizard but is there a direct way in the 
> download syntax to do it? So the end user doesn't have to run the 
> wizard and the leading zeros are there when they open it?
>
> *Jason Wininger*
>
> *IS Applications Programmer*
>
> *Diamond Chain Company*
>
>------------------------------------------------------------------------
>
>_______________________________________________
>download-list mailing list
>download-list at cedarville.edu
>http://mail.cedarville.edu/mailman/listinfo/download-list
>  
>
Try FORMAT QUOTE in your download statement.  That should convince Excel 
that all the values are text.  The flip side is that your "real" numbers 
won't "add" in Excel when you do that.

You could also go tab delimited (FORMAT TAB) and then create an 
idescriptor to protect your non number numbers with quotes.  That way 
your dates, counts etc will be understandable as such by Excel but  your 
leading zeros will be left alone.

I-Desc code for students.id, single quotes surround double quote   ->  
'"':STUDENTS.ID:'"' 

Or you could just define a special format in Excel that is seven numbers 
with leading zeros and apply that to your result as required, it might 
be less work :)

Good luck!

-------------- next part --------------
A non-text attachment was scrubbed...
Name: jacob.geluk.vcf
Type: text/x-vcard
Size: 284 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20050118/3d602142/attachment.vcf>