Remember Me?

#1
September 24th 05, 10:08 PM
 sctroy Posts: n/a
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*")

When I try to edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*")
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,"*2-1*")+COUNTIF(A1:F16,"*1-2*") 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.

1-10 9-2 3-8 4-7 5-6
4-3 10-8 9-7 1-6 5-2
8-9 1-7 2-6 3-5 4-10
4-6 5-10 9-1 2-8 3-7
10-6 7-5 2-1 8-4 9-3
5-9 6-8 7-10 3-2 1-4
3-1 4-9 8-5 6-7 10-2
7-2 6-3 5-4 9-10 8-1
7-8 2-4 10-3 1-5 6-9
6-5 10-1 2-9 8-3 7-4

There are 5 columns here

--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928

#2
September 25th 05, 01:25 AM
 Myrna Larson Posts: n/a

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,"*1-2*")+COUNTIF(A1:F16,"*2-1*")
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,"*2-1*")+COUNTIF(A1:F16,"*1-2*") 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.

1-10 9-2 3-8 4-7 5-6
4-3 10-8 9-7 1-6 5-2
8-9 1-7 2-6 3-5 4-10
4-6 5-10 9-1 2-8 3-7
10-6 7-5 2-1 8-4 9-3
5-9 6-8 7-10 3-2 1-4
3-1 4-9 8-5 6-7 10-2
7-2 6-3 5-4 9-10 8-1
7-8 2-4 10-3 1-5 6-9
6-5 10-1 2-9 8-3 7-4

There are 5 columns here

#3
September 25th 05, 04:13 AM
 sctroy Posts: n/a

You did it. Works great. Thanks a lot.

--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ishika Excel Discussion (Misc queries) 0 June 16th 05 06:53 PM alnav89 Excel Worksheet Functions 2 April 26th 05 07:02 PM Judy T New Users to Excel 3 March 24th 05 12:04 AM johmoc Excel Discussion (Misc queries) 0 March 18th 05 04:53 PM hon123456 Excel Discussion (Misc queries) 2 January 13th 05 10:40 AM

All times are GMT +1. The time now is 06:37 AM.