view the reference and not the value

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
 
F

Frank Kabel

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'
 
Top