Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 42
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can I make cell "yes" equal 1, "no" equal 0 can I make cell yes equal 1, no equa Excel Discussion (Misc queries) 4 April 22nd 23 06:09 AM
Hiding rows which equal zero sum value Mike Excel Discussion (Misc queries) 3 May 25th 08 07:38 PM
Rolling Monthly Amounts to Annual Monthly Amounts RV Excel Discussion (Misc queries) 0 August 29th 06 04:56 PM
11 $ amounts, 6 of the amounts must equal $3854.12, which 6? Marianne Excel Discussion (Misc queries) 2 August 26th 06 12:39 AM
PIVOT TABLE - hiding records with CALCULATED item values equal to Pele Excel Discussion (Misc queries) 0 March 10th 06 05:15 PM


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"