CSV from Filepro dropping leading zeros

Chris Sellitto sellich at guaranteedreturns.com
Wed Sep 16 09:21:45 PDT 2009


> -----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



More information about the Filepro-list mailing list