cell displays formula instead of value
 

Hello,

I have a weird problem in a workbook with two worksheets.
I want to display values in sheet2 that have been manually entered o
sheet1. The target where the data's supposed to be displayed are merge
cells

For example in A10:A18 of Sheet2 I entered
=Sheet1!B19

On A19:A37 of Sheet2:
=Sheet1!B20

and so forth.

However, instead of displaying the value of the reference, all cel
ranges in column A of sheet2 display the whole formula (=sheet1!...).
I have tried changing the number format of the cells, but this didn'
help.

Once (I can't remember how), I managed to get a value displaye
properly in one cell, so I copied it to the other cells. But as soon a
I tried to change the reference in the formula (i.e. from =Sheet1!B19 t
=Sheet1!B20), the only thing that gets displayed in the cell is th
formula.

What am I doing wrong

--
Message posted from http://www.ExcelForum.com

cell displays formula instead of value
 

I'm sorry!
just realized that I put this under the wrong headline...it wa
supposed to go to General Excel questions..

--
Message posted from http://www.ExcelForum.com

cell displays formula instead of value
 

select all the cells and do
Edit=Replace
what: =
With: =

this should make the cells display the results of the formulas.

--
Regards,
Tom Ogilvy

"viilis " wrote in message
...
I'm sorry!
just realized that I put this under the wrong headline...it was
supposed to go to General Excel questions...


---
Message posted from http://www.ExcelForum.com/

cell displays formula instead of value
 

Hi
see your post in public.excel

--
Regards
Frank Kabel
Frankfurt, Germany

"viilis " schrieb im
Newsbeitrag ...
Hello,

I have a weird problem in a workbook with two worksheets.
I want to display values in sheet2 that have been manually entered on
sheet1. The target where the data's supposed to be displayed are
merged
cells

For example in A10:A18 of Sheet2 I entered
=Sheet1!B19

On A19:A37 of Sheet2:
=Sheet1!B20

and so forth.

However, instead of displaying the value of the reference, all cell
ranges in column A of sheet2 display the whole formula (=sheet1!...).
I have tried changing the number format of the cells, but this didn't
help.

Once (I can't remember how), I managed to get a value displayed
properly in one cell, so I copied it to the other cells. But as soon
as
I tried to change the reference in the formula (i.e. from =Sheet1!B19
to
=Sheet1!B20), the only thing that gets displayed in the cell is the
formula.

What am I doing wrong?


---
Message posted from http://www.ExcelForum.com/