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.