Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 24th 05, 10:08 PM
sctroy
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=470502


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

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   Report Post  
Old September 25th 05, 04:13 AM
sctroy
 
Posts: n/a
Default


You did it. Works great. Thanks a lot.


--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=470502



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Excel events even in edit mode.... Ishika Excel Discussion (Misc queries) 0 June 16th 05 06:53 PM
EDIT FORMULA BAR in excel 2003? why not? where is it? alnav89 Excel Worksheet Functions 2 April 26th 05 07:02 PM
edit Excel spread sheet Judy T New Users to Excel 3 March 24th 05 12:04 AM
Scan and edit document in excel 2003. johmoc Excel Discussion (Misc queries) 0 March 18th 05 04:53 PM
How to switch to edit the cell hon123456 Excel Discussion (Misc queries) 2 January 13th 05 10:40 AM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017