Reference cells from another worksheet problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Worksheet call MAIN
Worksheet call OTHER

In a cell on the OTHER worksheet I have =MAIN!A1. The value in A1 in the
MAIN worksheet is space, but it appears as 0.0.0000 in the cell on OTHER
which has a format of general. How do I get rid of 0.0.0000.
 
Hi Neil,

Recheck your formula. I tried what you wrote and it worked for me. You
might want to Right click the cell in question and try Number/Text.



Hope this helps
 
Hi Keith,

Formula is =MAIN!W8

W8 is blank. Whether format is general or text, the value that appears in
the cell on the Other worksheet still appears as 0.0.0000. I then try to
reset the format on the other worksheet cell from general to text and when I
do this it changes the value from 0.0.0000 to 0.

Any other thoughts.

Thanks.
 
You must log in or register to reply here.

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

Excel Highlighting duplicates 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Code to format cells on several worksheets 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I lookup data from multiple worksheets? 2
AVERAGE cells on another worksheet when the range is calculated 1
Using cell as worksheet reference (macro) 1
Changing relative cell reference 2

Back
Top