zeros show as dashes in spreadsheet, want to show 0.
 

My cells are formatted as Accounting. In "Tools, Options, View, Display all
zero values" is checked. I do not have any custom formulas in my cells to
return a dash when the value is zero. Yet 99% of the zero values are showing
as dashes, with one showing as a zero, and one as (0). How can I show the
numeral zero instead of dashes? Thank you.

Answer: zeros show as dashes in spreadsheet, want to show 0.
 

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:

1. Select the cells that you want to display as zeros instead of dashes.
2. Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
3. In the Format Cells dialog box, select the "Number" tab.
4. Under "Category," choose "Custom."
5. In the "Type" field, enter the following format code:
   Formula:

   ---

   0.00;-0.00;0 


   ---

6. 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.

zeros show as dashes in spreadsheet, want to show 0.
 

format as currency
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"emilyann" escreveu:

My cells are formatted as Accounting. In "Tools, Options, View, Display all
zero values" is checked. I do not have any custom formulas in my cells to
return a dash when the value is zero. Yet 99% of the zero values are showing
as dashes, with one showing as a zero, and one as (0). How can I show the
numeral zero instead of dashes? Thank you.

zeros show as dashes in spreadsheet, want to show 0.
 

Accounting format is _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
so the 0 part is the _($* "-"??_)
You can substitute 0 in this part & make it line up with everything else by
using this format:
_($* #,##0.00_);_($* (#,##0.00);_(* "0"??_);_(@_)


"emilyann" wrote in message
...
My cells are formatted as Accounting. In "Tools, Options, View, Display
all
zero values" is checked. I do not have any custom formulas in my cells to
return a dash when the value is zero. Yet 99% of the zero values are
showing
as dashes, with one showing as a zero, and one as (0). How can I show the
numeral zero instead of dashes? Thank you.