I'm having a problem here... recently upgraded to a new version of excel and I've been looking in all the options can't seem to find a solution.

It seems whenever I enter a formula referencing a blank cell on another sheet, instead of displaying a blank value like on the other sheet it shows a "0". I still want to display 0 values where appropriate, so selecting "do not show zero values" doesn't work for me.

I just want it to show a zero in cells formated at numeric, and blank values (nothing) in cells formatted as either general or text or whatever.

Any help would be appreciated,

Thanks.

Chris