Forum Discussion
FischerBuechele
Sep 05, 2024Copper Contributor
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
- 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.
FischerBuechele
Copper Contributor
on my main sheet this did not work, any way i could privately send you the doc for help?
Riny_van_Eekelen
Sep 06, 2024Platinum Contributor
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.
- FischerBuecheleSep 06, 2024Copper ContributorI just sent you one thanks so much!!!