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.