Formatting results =0 to dashes

[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

 

[opeel]

=IF(A2-B2=0,"-",A2-B2

 

[Biff]

Hi dewdrop!

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

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

Biff

 

[DDM]

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.

 

[Guest]

thanks, but i didn't want to use the if formula...

 

[Guest]

OK i got it.
thanks Biff, DDM & Opeel! =)