Dropping .00's on export word command

Mike Schwartz mike.appleton.wi at sbcglobal.net
Tue Jun 20 08:03:16 PDT 2006


> >     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     




More information about the Filepro-list mailing list