Hiding amounts that equal 0

  • Thread starter Thread starter Sandi
  • Start date Start date
S

Sandi

Is there a formula that you can use that says if the amount is 0 nothing
showes in box?
 
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.
 
Select the range; Right click>Format Cells>select Custom and type the below

General;-General;""

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
Tax formula tests for multiple filing statuses and income amounts 1
IF/OR/AND function in a formula 5
Formula Help 1
problem with formulas (2) 7
Access #Error & Excel Pivot 0
Hiding amounts 3
Macro to hide rows 4

Back
Top