Format changes

A

Arun

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.
 
D

Don Guillett

I just did this
in cell c2 typed = in the formula bar>selected 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
 
A

Arun

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.
 
P

Peo Sjoblom

It doesn't matter, the cell is seen as text by excel. I have had the same
problem with some old workbooks
where I always had to force a calculation using edit replace replacing the
equal sign with the equal sign.
Only way I could solve that was to do a real replace and replace equal sign
with something like

^^=

that way I would get a text string, then I would select the whole damn
sheet, do copy and paste into a new workbook, then do a reverse replace and
replace ^^= with =


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top