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