Steve Hanson wrote:
in calc I am trying to do a simple formula like this g35-g36 when the dollar
value is the same it gives me a -.01 dollar valve. so someplace it is adding 1
cent when it should be 0. Example customers bill is 47.93 (g35) they paid
47.93 (g36) balance due (g37) shows .01
Thanks for the help
Steve Hanson
[EMAIL PROTECTED]
Steve
Could I suggest that you make a change to the spreadsheet to display 3
decimal places on the g35 field. This can be done using the >Format
>Cells then the number tab and change the decimal places to 3. I think
the calculation of g35 results in an odd .001 at the end.
Please let us know the result.
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
