...I want to display a hyphen instead of zero...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell linked to a cell in another worksheet at the beginning of the
month, the linked cell has data generated and shows a dollar value. Up until
the end of the month $0.00 is displayed in that cell. Until the data is
generated I would like a Hyphen to be displayed.

I thought that I should add =IF 0,-, or =IF 0,"-", as a prefix to the link,
but various combinations of this don't seem to work.

Could someone give me a hint?

Darrell
 
You need only use a custom format. One the menu: Format | Cells, then click
on the Number tab and choose Custom in the left panel

In the right portion, under Type, paste in this string

_($* #,##0.00_);_($* (#,##0.00);_(* "-"??_);_(@_)
 
TY

Duke Carey said:
You need only use a custom format. One the menu: Format | Cells, then click
on the Number tab and choose Custom in the left panel

In the right portion, under Type, paste in this string

_($* #,##0.00_);_($* (#,##0.00);_(* "-"??_);_(@_)
Click to expand...
 
Back
Top