you could
on sheet2 go to
tools
options
view
and uncheck zero values

or you could have a condition in the formula
something like
=if(sheet1!A55=0,"",sheet1!A55)

--
Greetings from New Zealand
Bill K

"Crazy" <Crazy.1zl18y_1133811900.706@excelforum-nospam.com> wrote in message
news:Crazy.1zl18y_1133811900.706@excelforum-nospam.com...
>
> Hi,
> I have a workbook where on Sheet 2 I have certain cells =to cells on
> sheet 1. If those cells are blank on sheet 1, it is showing up as "0"
> in the cells on sheet 2. I don't want "0", I want blank if the cells
> are blank in sheet 1. What should I be doing?
>
> Thank you from an excel idiot!
>
>
> --
> Crazy
> ------------------------------------------------------------------------
> Crazy's Profile:
> http://www.excelforum.com/member.php...fo&userid=8251
> View this thread: http://www.excelforum.com/showthread...hreadid=490840
>