Re: Witango-Talk: Zip Codes into a CSV Excel file

[Robert Garcia]

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