Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
How do i make it so Zeros dont show up in excel
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
Hello,
Don't type them...? Sorry, not sure what you are trying to do. --JP On Oct 7, 5:11 pm, JRID06 wrote: How do i make it so Zeros dont show up in excel |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
I am trying to make it so if the result of a formula is 0 it will leave the
cell blank instead of a 0 showing up. "JP" wrote: Hello, Don't type them...? Sorry, not sure what you are trying to do. --JP On Oct 7, 5:11 pm, JRID06 wrote: How do i make it so Zeros dont show up in excel |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
Go to the Tools menu, choose Options, then the View tab, and uncheck the
"Zero Values" option. This will hide ALL zero values that are the result of a calculation. To hide zeros only on certain cells, format those cells with the following custom number format. Note the trailing semi-colon. General;General; "JRID06" wrote in message ... I am trying to make it so if the result of a formula is 0 it will leave the cell blank instead of a 0 showing up. "JP" wrote: Hello, Don't type them...? Sorry, not sure what you are trying to do. --JP On Oct 7, 5:11 pm, JRID06 wrote: How do i make it so Zeros dont show up in excel |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
=IF(yourformula=0,"",yourformula)
e.g. +IF(A1-B1=0,"",A1-B1) Watch this..........0 may be just a formatting issue and you really have 0.0000000123 in the cell. Gord Dibben MS Excel MVP On Sun, 7 Oct 2007 14:29:02 -0700, JRID06 wrote: I am trying to make it so if the result of a formula is 0 it will leave the cell blank instead of a 0 showing up. "JP" wrote: Hello, Don't type them...? Sorry, not sure what you are trying to do. --JP On Oct 7, 5:11 pm, JRID06 wrote: How do i make it so Zeros dont show up in excel |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
Another way is to hide them using conditional formatting. Highlight
the cells you want to be affected in this way, then Format | Conditional Formatting, then choose Cell Value Is, Equal To, 0 (zero), then click the Format button and choose a foreground colour of white, then OK twice. The cell will appear to be empty (white on white), but the zero (and formula) is still there. Hope this helps. Pete On Oct 7, 10:29 pm, JRID06 wrote: I am trying to make it so if the result of a formula is 0 it will leave the cell blank instead of a 0 showing up. "JP" wrote: Hello, Don't type them...? Sorry, not sure what you are trying to do. --JP On Oct 7, 5:11 pm, JRID06 wrote: How do i make it so Zeros dont show up in excel- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hide 0's
Great to see some humor here
"JP" wrote: Hello, Don't type them...? Sorry, not sure what you are trying to do. --JP On Oct 7, 5:11 pm, JRID06 wrote: How do i make it so Zeros dont show up in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Unhide Hide again | New Users to Excel | |||
Hide #DIV/0! | Excel Worksheet Functions | |||
hide "#VALUE!" | Excel Worksheet Functions | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
how to hide #N/A's? | Excel Worksheet Functions |