Adjusting a formula to return Blank instead of a zero

hai folks,

I am using Macros to "delete a column and insert a new column by copying the same formulas(sum) and number formats".While doing this, the formula is calculating the sum of blank cells and returning zero(which i do not want to display).if i use the spaces instead of zero to display,it is erasing the formula.can u plz help me out with this.

When i used tools->options->view: unchecked the zeros values ...i cannot really enter a zero value for summing,as well the previous cell which contain zero is also removed.

Hi,

Could you use a if statement to return blank if zero.


or

format the cells as

[<0]General;#,###

VBA Noob

Thank U very much

Hi,
I tried with formatting cells with [<0]General;#,###.Its working good,It deosn't display any zeros.But when i enter the data in the cells with all the zeros,It is not displaying the sum.It is just displaying a blank even the sum is zero.can u please tell me How to resolve this.

Can you post an example

VBA Noob

This sheets contains the macros which removes the oldest year statistics and enters the new year statistics when we click on the "Format Table".The problem is with the "Mad-uc".The column having the formula displays the Zero by default.if we try to make it blank it shows the blank even if the sum is zero.

http://savefile.com/projects/1082293