___
Sent with SnapperMail
www.snappermail.com
.. Original Message ...
On Fri, 6 May 2005 11:05:37 +1000 Jason Schulz [EMAIL PROTECTED] wrote:
Steve,
Are the zip codes you are working with fixed length, or is the pad
length (number of zeros on the front) fixed?
If you can generate an
You might try putting the values in single quotes so that it thinks
its a text value instead of numeric.
cprefix=@sq csuffix=@sq,
On 5/5/05, Fogelson, Steve [EMAIL PROTECTED] wrote:
I am writing an array into a csv file with the following:
@var request$Labels aprefix=
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
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: witango-talk@witango.com
Subject: Re: Witango-Talk: Zip Codes into a CSV
-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
anyone ever tried saving a table as an .xls file?
I know that if you pull that trick on the web client, sending them
the foundset as an xls file, it opens excel and none of the formats
are stepped on.
On May 5, 2005, at 1:33 PM, Robert Garcia wrote:
You are correct.
--
Robert Garcia
President
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: witango-talk@witango.com
Subject: Re: Witango-Talk: Zip Codes into a CSV Excel file
You are correct.
--
Robert
:33 PM
To: witango-talk@witango.com
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
Steve,
Are the zip codes you are working with fixed length, or is the pad length (number of zeros on the front) fixed?
If you can generate an html file for Excel then CSS can be applied to tell Excel to treat the numbers correctly. If you want to stay away from styles, then td x:str='001>001/td>
: Thursday, May 05, 2005 8:06
PMTo: WitangoSubject: Re: Witango-Talk: Zip Codes into a
CSV Excel file
Steve,
Are the zip codes you are working with fixed length, or is the pad length
(number of zeros on the front) fixed?
If you can generate an html file for Excel then CSS can be applied
10 matches
Mail list logo