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


--
Carnadyne
------------------------------------------------------------------------
Carnadyne's Profile: http://www.excelforum.com/member.php...o&userid=27443
View this thread: http://www.excelforum.com/showthread...hreadid=469528