#### CAPT.PT

##### New Member
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

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### ChrisUK

##### Well-known Member
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

##### MrExcel MVP
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

##### New Member
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!

##### MrExcel MVP
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.

##### MrExcel MVP
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

Replies
12
Views
257
Replies
0
Views
149
Replies
2
Views
94
Replies
1
Views
124
Replies
4
Views
124

1,181,531
Messages
5,930,443
Members
436,738
Latest member
JFry

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back