=IF([Book1]Sheet1!$A$1<"",[Book1]Sheet1!$A$1,"")

the cell ( in book2)with this formula will read whatever is in the cell
specified on the sheet specified, in the workbook specified.
"PAM" wrote:

Since our hospital updated to Excel 2003 it puts a 0 place marker in the
spaces where I paste a special link and I want to get rid of them, how do I
do it?