Use the ROUND() function to make sure that only 2 decimals are used.

"Bzltyr" wrote in message
...
I am an accountant and I am trying to prepare a txt or csv file for import.
I have 4600 lines for journal entries that have to balance to zero.
I get an error message that says I cannot post because the journal entry
is
out of balance. It says 5,242,232.21 does not equal 5,242,232.21.
When I total the journal entry it totals to 5,242,232.210000001 debit and
5,242,232.2100000002 credit. They do not balance.
I have checked to the 20th place after the decimal and all the line have
zeros after the the digits for cents for example 4.22000000000000000000
plus
(4.22000000000000000000) equals (0.0000000000156897).

All numbers display with values only in the two decimals for cents and
then
zeros to the 20th decimal but they do not balance to zero.