<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Courier New, Courier, monospace">Yes, the apostrophe trick
works, but the apostrophe is still in the column as a visible character.<br>
<br>
FYI, I am using this on the web. Users request the grid of data to be a
csv file and filepro creates the csv. <br>
That csv file is automatically loaded into Excel on the web users PC.<br>
<br>
There is no loading or importing of this data.<br>
<br>
Richard<br>
</font><br>
Chris Sellitto wrote:<br>
<blockquote
cite="mid2DBF4318DEEE234BA68949B98AEA10F30260355D@NYEXCH1.extranet.guaranteedreturns.com"
type="cite">
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From:
</pre>
</blockquote>
<pre wrap=""><!----><a class="moz-txt-link-abbreviated" href="mailto:filepro-list-bounces+sellich=guaranteedreturns.com@lists.celestial.com">filepro-list-bounces+sellich=guaranteedreturns.com@lists.celestial.com</a>
</pre>
<blockquote type="cite">
<pre wrap="">[<a class="moz-txt-link-freetext" href="mailto:filepro-list">mailto:filepro-list</a>-
<a class="moz-txt-link-abbreviated" href="mailto:bounces+sellich=guaranteedreturns.com@lists.celestial.com">bounces+sellich=guaranteedreturns.com@lists.celestial.com</a>] On Behalf
</pre>
</blockquote>
<pre wrap=""><!---->Of
</pre>
<blockquote type="cite">
<pre wrap="">Larry S. Weaver Jr.
Sent: Wednesday, September 16, 2009 10:56 AM
To: filePro Mailing List
Subject: Re: CSV from Filepro dropping leading zeros
Add an apostrophe (')to the front of the field. That will tell Excel
</pre>
</blockquote>
<pre wrap=""><!---->to
</pre>
<blockquote type="cite">
<pre wrap="">treat the field as a text instead of a number.
Larry
Larry Weaver, Jr. - Dellem Associates, Inc.
Ph: 813-963-5353 Ext: 101; Fax: 813-962-3164
E-mail: <a class="moz-txt-link-abbreviated" href="mailto:lweaverjr@dellem.com">lweaverjr@dellem.com</a>
Richard D. Williams wrote:
</pre>
<blockquote type="cite">
<pre wrap="">When I create a csv file from filepro and open it with Excel,
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->leading
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">zeros are drop.
Is there any way to "tell" Excel not to do this?
Are there any formatting variables that can be included into the csv
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->file?
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Richard D. Williams
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
Larry,
When using the apostrophe, how do you prevent the apostrophe from being
displayed when it is opened in Excel?
Christopher Sellitto
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
<pre wrap="">
<hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a>
Version: 8.5.409 / Virus Database: 270.13.100/2375 - Release Date: 09/16/09 05:51:00
</pre>
</blockquote>
</body>
</html>