| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a cell in Excel to show a dash instead of 0.00?
In Excel, I have two cells that are both formatted as accounting, decimal 2
and symbol none. One cell returns a dash -, the other 0.00. I want both cells to return a -. I have tried to paint the formatting but it still doesn't work. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format a cell to reflect a NIC's MAC Address ? (put in dash | Excel Worksheet Functions | |||
| Dash in format | Excel Discussion (Misc queries) | |||
| Is there a way to not show a dash as a zero in Excel chart? | Charts and Charting in Excel | |||
| understanding dash dash in a excel formula | Excel Worksheet Functions | |||
| how do i stop excel from changing a dash to a zero in a cell? | Excel Worksheet Functions | |||
Threaded Mode
