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

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
 
G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking sheets how do I display the zeros (0) as blank cells 1
How do I display text when a cell value is 0 for accounting? 2
Combining data from multiple workbooks 2
Zeros displaying in cell when using = sign 1
Counting Zeros in a row until encounter first non-zero value 9
Month value 3
Average cells with #DIV/0! 4
If function across sheets prints value of cell 4

Top