Dropping .00's on export word command

[GCC Consulting]

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of Mike Schwartz
> Sent: Tuesday, June 20, 2006 11:03 AM
> To: filepro-list at lists.celestial.com
> Subject: RE: Dropping .00's on export word command
> 
> 
> > >     I've viewed the raw output file in a word processor 
> to make sure 
> > > that the ".00"'s are really not in the output file and 
> are not being 
> > > cut off by Excel.  I am running filePro 5.0.14 on SCO 
> Open Server, 
> > > but I believe this has been the case for all versions of filePro.
> > [...]
> 
>      When I viewed the output .WP file with "less" on the SCO 
> Open Server Box, the .00's were already missing.  (I hadn't 
> attempted to FTP the file to a Windows box or open it with 
> Excel or any other spreadsheet program yet.)
> 
>       The data on in "less" looked like:
> 
> "MAY","132"
> 
> when I expected to see:
> 
> "MAY","132.00"
> 
>      Even worse, the final zero always seems to get dropped 
> in filePro numeric fields, so the June data looked like:
> 
> "JUNE","206.4"
> 
>      As I mentioned, I believe this has always been the 
> behavior with "export word".  It's just that I will have to 
> write almost 1,000 "work around" lines in order to fix this.  
> I was hoping for a "magic bullet"...  
>     
> Thanks,
> 
> Mike     
> 
> 
Try aa(8,#)=invoice(17) or aa(8,*)=invoice(17)

Richard Kreiss
GCC Consulting