You are correct.
--
Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/
On May 5, 2005, at 10:42 AM, Wilcox, Jamileh ((HSC)) wrote:
Nope, if it's imported/opened the field as a text, any leading zeroes are gone. You have to force Excel to use the wizard so that you can tell it the field is text before it actually touches the data. (Changing the .csv ending to a .txt will do it.)
I dunno if you're trying to do an automatic open...maybe prefixing with
a single quote (Excel's denotation for a text field) or enclosing in
double-quotes?
-----Original Message----- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 12:36 PM To: [email protected] Subject: Re: Witango-Talk: Zip Codes into a CSV Excel file
When excel opens a document, it looks at the data and tries to determine
the datatype and format appropriately. When you open, and it treats as a
number, just select that whole row of cells, and go to format menu, and
cells. Change the format from whatever type of number it guessed to
"Text". And it should now display the data correctly.
--
Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/
On May 5, 2005, at 10:18 AM, Fogelson, Steve wrote:
I am writing an array into a csv file with the following:
<@var request$Labels aprefix="" asuffix="" rprefix="" rsuffix="<@crlf>" cprefix="" csuffix=",">
Everything works great except when I open it with excel, it
removes leading zeros for zip codes. Evidently it thinks it is a numeric
field. If you open the csv file with NotePad, it is fine.
Any suggestions how to handle this?
Thanks
Steve Fogelson
Internet Commerce Solutions
______________________________________________________________________ __
TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
______________________________________________________________________ __
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________ __
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
