linked cells show "0"

L

Lenny

I set up links within a number of cells from worksheet 1 to various cells in
worksheet 2. The cells, on worksheet 2, instead of being blank are showing
"0". Is there a way to eliminate the 0 so the cell is blank also?

Regards - Lenny
 
D

Dave Peterson

=if(sheet2!a1="","",sheet2!a1)

Just check first.
I set up links within a number of cells from worksheet 1 to various cells in
worksheet 2. The cells, on worksheet 2, instead of being blank are showing
"0". Is there a way to eliminate the 0 so the cell is blank also?

Regards - Lenny
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Word macro that can call cells out of Excel for a find and replace 0
need help in fine-tuning a formula that removes blank cells in a column range 3
Copying linked sheet 2
3d reference 6
VBA Export to PDF 0
Pasting a cell into bookmarked table from excel vba 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top