| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
...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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| how to display heading of column corresponding to the cell | Excel Worksheet Functions | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Threaded Mode
