Dropping .00's on export word command

Kenneth Brody kenbrody at bestweb.net
Tue Jun 20 07:44:00 PDT 2006


Quoting Mike Schwartz (Tue, 20 Jun 2006 09:19:25 -0500):
[...]
> 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.
[...]

You say you looked at the raw file, but you don't say what you saw.

Are the trailing zeros in the file produced by filePro?  If so, then
this is an Excel issue, which I believe can be resolved by telling
Excel to format the column as dollars and cents.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list