I have had to reformat many times, but I guess it just had to do with
display, not zips, so the data didn't get altered.
--
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 2:13 PM, Wilcox, Jamileh ((HSC)) wrote:
I have this discussion with my users, quite...frequently. :)
-----Original Message-----
From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 3:33 PM
To: [email protected]
Subject: Re: Witango-Talk: Zip Codes into a CSV Excel file
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
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
