CSV from Filepro dropping leading zeros

Larry S. Weaver Jr. lweaverjr at dellem.com
Wed Sep 16 10:16:37 PDT 2009


Chris Sellitto wrote:
>> -----Original Message-----
>> From:
>>     
> Larry,
>
> When using the apostrophe, how do you prevent the apostrophe from being
> displayed when it is opened in Excel?
>
> Christopher Sellitto
>
>
>   
That should do it.  Excel shouldn't show a leading apostrophe.  It works 
correctly using OpenOffice Calc.  I don't have Excel, but have used this 
trick on it in the past.

If I remember correctly, the leading apostrophe trick worked all the way 
back to lotus 1-2-3.

Larry

Larry Weaver, Jr. - Dellem Associates, Inc.

Ph:  813-963-5353 Ext: 101;  Fax:  813-962-3164
E-mail:  lweaverjr at dellem.com



More information about the Filepro-list mailing list