help with changing cell no in formula

[SS]

I have this formula in cell =COUNTA(D4:G26)+R28

Now if I change the G26 to G27 by placing the cursor in front of the 6 and
backspacing and then enter a 7
so that it reads G27
the cell displays the formula rather than displaying the 0 which is the
formula answer.

Is it a setting or am I doing something wrong?

thanks

 

[Dave Peterson]

After you make the change:
Select the offending cell
Format it as General (or anything but Text)
Hit F2, then enter to have excel see the entry as a formula.

If you have lots to do:
Select the range to fix
Change the numberformat to General
Edit|Replace
what: = (equal sign)
with: = (equal sign)
replace all

Excel will see this as a change to each cell in the selection.

=======

Saved from a previous post.

Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.

 

[SS]

Thanks thats sorted the problem.
Now working.
thank you