Formula retuning dash when I add a new cell to the formula

[FischerBuechele]

Use this to track expenses, I think it was working in this copy but no the main book https://1drv.ms/x/c/7277ee0a8be44099/EevrJzRzlclAobMTAQsR_fMBG1MhaqfeS9PcXf6lrAg5WQ?e=Z6ihKU 

[#2 · Accepted solution]

@FischerBuechele The dash appears due to the Accounting number format. Customise it to show the same format for zero as for a positive number.

Your file contains links to another file on your system. Needed to break the links to be able to work with it. Adjusted the formats and all seems to work just fine. See attached.

[#3]

on my main sheet this did not work, any way i could privately send you the doc for help?

[#4]

@FischerBuechele To send the file only to me, you can send me a direct message and attach it there. Click on my name tag/avatar and wait for my profile page to open. Now you'll see a 'Message' button in the top right hand corner. Press it, and follow the instructions.

[#5]

I just sent you one thanks so much!!!