CSV from Filepro dropping leading zeros

Richard D. Williams richard at axzas.com
Wed Sep 16 09:37:48 PDT 2009


Yes, the apostrophe trick works, but the apostrophe is still in the 
column as a visible character.

FYI, I am using this on the web. Users request the grid of data to be a 
csv file and filepro creates the csv.
That csv file is automatically loaded into Excel on the web users PC.

There is no loading or importing of this data.

Richard

Chris Sellitto wrote:

>>-----Original Message-----
>>From:
>>    
>>
>filepro-list-bounces+sellich=guaranteedreturns.com at lists.celestial.com
>  
>
>>[mailto:filepro-list-
>>bounces+sellich=guaranteedreturns.com at lists.celestial.com] On Behalf
>>    
>>
>Of
>  
>
>>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
>>    
>>
>to
>  
>
>>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:  lweaverjr at dellem.com
>>
>>
>>
>>
>>
>>
>>Richard D. Williams wrote:
>>    
>>
>>>When I create a csv file from filepro and open it with Excel,
>>>      
>>>
>leading
>  
>
>>>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
>>>      
>>>
>file?
>  
>
>>>Richard D. Williams
>>>      
>>>
>
>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
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>  
>
>------------------------------------------------------------------------
>
>
>No virus found in this incoming message.
>Checked by AVG - www.avg.com 
>Version: 8.5.409 / Virus Database: 270.13.100/2375 - Release Date: 09/16/09 05:51:00
>
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090916/7ce7c514/attachment.html 


More information about the Filepro-list mailing list