Formatting results =0 to dashes

  • Thread starter Thread starter DewDrop
  • Start date Start date
D

DewDrop

HI,

I am using excel 2002.
Without using the IF formula, is there a way to format the
formula results (eg A1-B1) to display dashes "-" instead
of "0"?

thanks,
dewdrop
 
Hi dewdrop!

Here's one way. Create a custom number format and format
the cell as:

#,##0;(#,##0);-

Biff
 
DewDrop, use a custom number format (Format > Cells > Number > Custom).
Excel 2003 has one already defined:

_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

If it's not in your version of Excel, you can define it yourself. Just enter
it in the Type: field on the Number tab of the Format Cells dialog box. Note
that ";" is the separator, the third set of characters governs the display
of "0," and you don't have to include the fourth set (it governs text).

If you want something simpler, this will do:

#,##0.00_);(#,##0.00);-

For more information, search the topic "Create or delete a custom number
format" in Excel help.
 
Back
Top