Try it like this:
=IF(Sheet2!A1="","",Sheet2!A1)

instead of: =Sheet2!A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CarlaP" wrote:
I'm trying to link a blank cell (which will eventually contain text) to
another blank cell - different sheet but same workbook. The result is always
a "0" in the new cell. I've cleared both cells of all contents and formatting
to no avail.

I'm using Excel 2003. I'm grateful for any assistance.