Bo,

Use a formula like

=IF(Sheet1!A1="","",Sheet1!A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bo" wrote in message
...
I know this is proably a very simple thing.
I'm kinda new to excel so here goes.

I have a cell on sheet 3 of a notebook that I want to
read a certain cell on sheet 1
Reading is no problem. It's just when the source cell (Sheet 1)
is empty I get a 0 value in the cell on sheet 3.
I'd like to have the Cell on sheet 3 blank if the cell on sheet
1 is blank.

TIA!

Bo