Forum Discussion

FischerBuechele's avatar
FischerBuechele
Copper Contributor
Sep 05, 2024

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

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 
  • Riny_van_Eekelen's avatar
    Sep 05, 2024

    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.

Resources