Try Edit/Clear/Formats from the cells that are misbehaving. Then Edit/Replace,
and replace an equal sign with and equal sign (the latter is the same as
editing each formula).
On Sat, 24 Sep 2005 16:08:10 0500, sctroy
wrote:
When I try to edit this =COUNTIF(A1:F16,"*12*")+COUNTIF(A1:F16,"*21*")
I change the A1 to A2 and hit enter it quits functioning as a formula
and it fills the cell with text and numbers.
I can edit it one time and it will work. If I edit it twice I get the
text and numbers =COUNTIF(A1:F16,"*21*")+COUNTIF(A1:F16,"*12*") One
thing I did notice is that when I typed the formula in and hit enter
the number that showed up in the cell was aligned right and when I
edited it the first time and hit enter the number aligned left.
110 92 38 47 56
43 108 97 16 52
89 17 26 35 410
46 510 91 28 37
106 75 21 84 93
59 68 710 32 14
31 49 85 67 102
72 63 54 910 81
78 24 103 15 69
65 101 29 83 74
There are 5 columns here
