view the reference and not the value

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear All,


I am trying to bring in 5 sheets a value (text) from the
first sheet. When i typing the equal (=) in the sheet2 i
saw the reference and not the value.

Any solution for that ?

i am using the XP edition

Thanks in advance Manos
 
Hi
1. check that your target cell is not formated as 'Text'.
change the format to 'General' and re-enter the formula

2. If this does not help goto 'Tools - Options - View' and
uncheck 'Formulas'
 
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

Can I sort and not lose reference to the cell? 3
Code to format cells on several worksheets 2
Formula Bar show the location path file plus the formula 1
Excel 2007 - referencing a cell value from another worksheet withi 6
searching 2 values from 2 cells 5
Excel VBA to move cells to sheet2 based on selection in sheet1 0
how to write value 1
jump to cell in sheet2 when values in sheet1 is true 3

Back
Top