Dropping .00's on export word command
Mike Schwartz
mike.appleton.wi at sbcglobal.net
Tue Jun 20 07:19:25 PDT 2006
When I'm writing "export word" spreadsheet processing, I've noticed
that if field 17 in the invoice file has an edit of (8,.2) then a statement
like:
outfile(20)=invoice(17)
will produce output on the resulting .WP file that drops the trailing ".00"
off the numbers. For example, monthly fees that show 236.31, 136.00 and
283.42 will show on the finished spreadsheet like:
Month Fees
===== =======
Jan 236.31
Feb 136
Mar 283.42
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.
Is there some system variable that I can set that prevents this
behavior? If I did "export ascii", would that help? Any other suggestions?
I'm faced with a possible project that will require exporting a lot of
financial data, so I would prefer not to have to do something tedious, like:
aa(8,*)=invoice(17); outfile(20)=aa
(I don't even know whether or not that would work...)
Thanks,
Mike Schwartz
More information about the Filepro-list
mailing list