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
