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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a cell in Excel to show a dash instead of 0.00?
The 0.00 one is not exactly zero. Format temporarily as General and you'll
see there are some digits beyond the two decimals. Use ROUND() to round to zero -- Kind regards, Niek Otten Microsoft MVP - Excel "Reb3boys" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a cell in Excel to show a dash instead of 0.00?
<Use ROUND() to round to zero
I meant to two decimals -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... The 0.00 one is not exactly zero. Format temporarily as General and you'll see there are some digits beyond the two decimals. Use ROUND() to round to zero -- Kind regards, Niek Otten Microsoft MVP - Excel "Reb3boys" wrote in message ... 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 |
Reply |
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 |