How do I get rid of the 0 place markers on my forms in excel?

P

PAM

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?
 
U

ufo_pilot

=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.
 
Top