DEAD CELL ????

[CAPT.PT]

I have found a cell that will not accept information. Is this a common problem?
Let's say its 32B ... In row 32, =SUM(A32:J32
) adds all info except what number is in 32B.
Is there anything I can do to get it to work?
Thank you

 

[ChrisUK]

How sure are you 32B does not have some text in - space + your number ?

I don't think you can have "dead cells" in Excel

Chris

 

[Aladin Akyurek]

On 2002-10-25 05:58, CAPT.PT wrote:
I have found a cell that will not accept information. Is this a common problem?
Let's say its 32B ... In row 32, =SUM(A32:J32
) adds all info except what number is in 32B.
Is there anything I can do to get it to work?
Thank you

Cell 32B?

 

[CAPT-PT]

THANKS FOR RESPONDING...THERE IS NO FORMULA IN CELL 32B...A THROUGH J ARE ALL OPEN FOR INFO..THEY ALL WORK BUT THAT ONE CELL?
ALLADIN...ARE YOU QUESTIONING THE ROW AND CELL NUMBER...OK ITS B32.. I CAN PUT NUMBERS IN ANY CELL IN ROW 32...THE SUM OF ALL THESE CELLS ARE ADDED OK EXCEPT ONE CELL...WHATEVER ITS NUMBER...ANY OTHER HELP APPRECIATED!

 

[Aladin Akyurek]

On 2002-10-25 06:48, CAPT-PT wrote:
THANKS FOR RESPONDING...THERE IS NO FORMULA IN CELL 32B...A THROUGH J ARE ALL OPEN FOR INFO..THEY ALL WORK BUT THAT ONE CELL?
ALLADIN...ARE YOU QUESTIONING THE ROW AND CELL NUMBER...OK ITS B32.. I CAN PUT NUMBERS IN ANY CELL IN ROW 32...THE SUM OF ALL THESE CELLS ARE ADDED OK EXCEPT ONE CELL...WHATEVER ITS NUMBER...ANY OTHER HELP APPRECIATED!

OK, B32. Would you check whether this cell houses a number, using:

=ISNUMBER(B32) ?

 

[Mark W.]

On 2002-10-25 05:58, CAPT.PT wrote:
I have found a cell that will not accept information. Is this a common problem?
Let's say its 32B ... In row 32, =SUM(A32:J32
) adds all info except what number is in 32B.
Is there anything I can do to get it to work?
Thank you

Make sure that B32 is formatted with a number format other than Text, choose the Data | Text to Columns... menu command, and press [ Finish ].
This message was edited by Mark W. on 2002-10-25 11:33