Forum Discussion
Formula retuning dash when I add a new cell to the formula
- 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 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.
- FischerBuecheleSep 05, 2024Copper Contributoron my main sheet this did not work, any way i could privately send you the doc for help?
- Riny_van_EekelenSep 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!!!