Simple Formula, showing up odd

[bhanu2003]

Hi,

i am doing a simple thing.

i have two sheets, having data in one of them(say Sheet2), say A1:B20

in the other sheet i am using these values,

Say in one if the cells in Sheet1, i say A100=sheet2!A1, i expect the value to come up, but then the cell in sheet one(A100) shows me the formula instead.

Any IDEAS, please.

Thanks in advance,
Bhanu

 

[Brian from Maui]

Click in the cell with the formula showing and go to Edit/Replace and replace = with =. Somehow the cell with the formula got formatted as Text.

 

[bhanu2003]

Thanks, Brian. That is done.

Any way to stop this from hapenning, as i know this is a sheet with a few merged cells, that is all.

Thanks again,
Bhanu