You have the cell formatted as TEXT.

--
Don Guillett
SalesAid Software

"Arun" wrote in message
...
That's what I would expect. My cell c2 shows "=a2&3"
It is only on this particular spreadsheet. If I open a new blank one it
works just as you described Don. I'm trying to figure out what setting is
making this happen on this particular sheet.

"Don Guillett" wrote:

I just did this
in cell c2 typed = in the formula barselected cell a2 to get =a2( a2
contains =3*2 6)went back to the formula bar to the end and typed "&3"
to
get 63


--
Don Guillett
SalesAid Software

"Arun" wrote in message
...
I am having a terrible time of getting the cells to show a formula
result
instead of the formula itself. I created a formula of a cell reference
by
typing "=" then selecting the appropriate cell. Worked fine. But then
I
when I concatenate by adding &" text", the cell changes to show the
cell
contents instead of the formula target (=A24&" text"). In fact, I can
replace the cell contents with simple formula such as =6+3 and the cell
will
show this instead of 9.

I found I could fix the problem by doing a replace function of 'Find: =
,
Replace: ='. But then everytime I try to modify the cell contents it
reverts
back to showing the formula therefore requiring another Find/Replace be
run.

Please help.