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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get rid of the 0 place markers on my forms in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/41280-how-do-i-get-rid-0-place-markers-my-forms-excel.html)

PAM

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

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?

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.
"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?

All times are GMT +1. The time now is 04:26 PM.