Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding amounts that equal 0
Is there a formula that you can use that says if the amount is 0 nothing
showes in box? -- Sandi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding amounts that equal 0
Use ToolsOptionsView and uncheck Zero Values
-- __________________________________ HTH Bob "Sandi" wrote in message ... Is there a formula that you can use that says if the amount is 0 nothing showes in box? -- Sandi |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding amounts that equal 0
=IF(A1=0,"",A1)
=IF(A1="","",A1) Gord Dibben MS Excel MVP On Wed, 8 Jul 2009 15:22:01 -0700, Sandi wrote: Is there a formula that you can use that says if the amount is 0 nothing showes in box? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding amounts that equal 0
Hi,
besides the suggestions you already have you can create a custom format such as: General;General;; Choose Format, Cells, Number tab, Custom and enter something like the above. Change the number of decimal or you can use conditional formatting: Format, Condtional Formatting, choose equal to from the second box and enter 0 in the next box, then click Format and on the Font tab set the color to White. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sandi" wrote: Is there a formula that you can use that says if the amount is 0 nothing showes in box? -- Sandi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding amounts that equal 0
Select the range; Right clickFormat Cellsselect Custom and type the below
General;-General;"" If this post helps click Yes --------------- Jacob Skaria "Sandi" wrote: Is there a formula that you can use that says if the amount is 0 nothing showes in box? -- Sandi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
Hiding rows which equal zero sum value | Excel Discussion (Misc queries) | |||
Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
11 $ amounts, 6 of the amounts must equal $3854.12, which 6? | Excel Discussion (Misc queries) | |||
PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) |