Hi there! It sounds like you're having trouble with your Excel spreadsheet displaying zeros as dashes instead of the actual number.
Here's what you can do to fix it:
- Select the cells that you want to display as zeros instead of dashes.
- Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
- In the Format Cells dialog box, select the "Number" tab.
- Under "Category," choose "Custom."
- In the "Type" field, enter the following format code:
- Click "OK" to apply the changes.
This format code tells Excel to display positive numbers with two decimal places, negative numbers with two decimal places and a minus sign, and zero values as simply "0".
Once you've applied this format to your cells, they should display zeros instead of dashes.