reference to other sheet doesnt work

J

jan

sheet 1: Sheet1. Cellcontent A2=1

sheet 2:

Try to write this:
=Sheet1!A2

Sadly, only the reference text shows up.

Any help on this one? Thank You

regards
 
J

jan

Sorry, the Excel is XP version with SP3.
Acctually this doesnt work:

Sheet2: E180 contains a text or a number.

Writing =Sheet2!E180 in a cell in sheet1 doesnt work.

The referencetext are just shown in cell, not the number/text from sheet2.

regards








jan skrev:
 
P

Paul B

Jan, is the cell in sheet to formatted as text? this will cause your
formula to show up, format the cell to something else and try it again.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
E

Elkar

Sounds like the cell the formula is in is formatted as Text. Try changing
the cell format to "General" then re-enter the formula.

HTH,
Elkar
 
Top