Forum Discussion

Trusted Cover User

Re: Excel formula not working when exported

Hi Mike thank you for your reply. The formula is a very simple formula ie =a2-a1 using the amounts from the trial balance that have been exported to excel. I use the exported trial balance and enter the accountant adjustments and create the simple subtraction formula to calculate the difference in order to enter a manual adjustment journal to reconcile month end amounts in MYOB. The formula always gives me a #VALUE and it seems that the amounts in the downloaded trial balance are text and not numbers. My own solution is to enter the trial balance figures in separate columns in order to calculate the difference. This is not ideal as it is double entering values, hence doubling my data entry time. Does MYOB export the trial balance amounts as text and not numbers?

3 Replies

Mike_James
Ultimate Cover User
1 year ago
Hi Lisa_BBP , the error is caused by the empty cells. They appear to be empty but might not be. If you edit one of those cells, then backspace (either in the cell or in the formula bar), then press Enter to update, the formula will work. So there must be a non-printable character in those cells.
I haven't found any other way to correct those cells; maybe someone else will have a suggestion.
Mike_James
Ultimate Cover User
1 year ago
PS the best solution would be for MYOB to make sure empty cells are empty, or at worst contain a zero.
Lisa_BBP
Trusted Cover User
1 year ago
Thanks for your kind reply Mike and thank you for the explanation and solution. I will try these options.