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