Trying to format a CSV file for import into Great Plains General Ledger, in order to do so the sum of the "amount" column must equal exactly zero.
however, the sum of the column is 0.000000000944.....
in the column of numbers there are no amounts which go beyond the second decimal place. the problem remains if I use the round() function.
if I multiply the cell contents by 100 the issue disappears. if I then divide the multiplied cells by 100 to return to the original values the issue returns.
any ideas?
Swimming Workout of the Day:
Favourite Swim Sets:
2020 National Masters Champion - M50-54 - 50m Butterfly
however, the sum of the column is 0.000000000944.....
in the column of numbers there are no amounts which go beyond the second decimal place. the problem remains if I use the round() function.
if I multiply the cell contents by 100 the issue disappears. if I then divide the multiplied cells by 100 to return to the original values the issue returns.
any ideas?
Swimming Workout of the Day:
Favourite Swim Sets:
2020 National Masters Champion - M50-54 - 50m Butterfly