CSV from Filepro dropping leading zeros
Larry S. Weaver Jr.
lweaverjr at dellem.com
Wed Sep 16 07:55:34 PDT 2009
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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
More information about the Filepro-list
mailing list