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
Bookmarks