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

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);_(* "-"??_);_(@_)

"Dr. Darrell" wrote:

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

TY

"Duke Carey" wrote:

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);_(* "-"??_);_(@_)

"Dr. Darrell" wrote:

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