Good afternoon,
I have a file that contains a journal entry that when formatted as a number correctly sums to 0, however, when saving as a CSV and trying to import into our accounting system it tells me the entry is out of balance. When I open the CSV file I get the sum of -1.93268E-12 which is why it is not importing. How do I eliminate this? I have tried copying to a new sheet, PS-Values, formatting, etc.
Thank you!
I have a file that contains a journal entry that when formatted as a number correctly sums to 0, however, when saving as a CSV and trying to import into our accounting system it tells me the entry is out of balance. When I open the CSV file I get the sum of -1.93268E-12 which is why it is not importing. How do I eliminate this? I have tried copying to a new sheet, PS-Values, formatting, etc.
Thank you!