Format changes
 

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.

Format changes
 

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.

Format changes
 

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.

Format changes
 

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.

Format changes
 

No, it's 'General'.

"Don Guillett" wrote:

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.

Format changes
 

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


"Arun" wrote in message
...
No, it's 'General'.

"Don Guillett" wrote:

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.