Can't Total Value in Given Cells

[Paul]

Not a new user of Excel...but, am having trouble adding
(w/the icon to add via Autosum)a few cell values...wonder
if I might have thrown a toggle swith somewhere to
prevent it from adding. (Other areas of spreadsheet seem
to be functioning OK)

 

[Microsoft]

try to sum it manually, if it doesn't work probably you have paste something
to this aria from a ".CSV" file or something similar, try to copy this cells
to a different workbook and "delete" those affected cells (not clear the
content)

 

[Gord Dibben]

Most common reason is the numbers are actually text.

Try this.....copy an empty cell. Select your range of numbers and paste
special(in place)>add>ok>esc

This should coerce them to real numbers.

If not, you may have some stray non-printing characters in the cells.

Use David McRitchie's TRIMALL macro to clear those.

Sub TrimALL()
'David McRitchie 2000-07-03 mod 2000-08-16 join.htm
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim cell As Range
'Also Treat CHR 0160, as a space (CHR 032)
Selection.Replace What:=Chr(160), Replacement:=Chr(32), _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
'Trim in Excel removes extra internal spaces, VBA does not
On Error Resume Next 'in case no text cells in selection
For Each cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
cell.Value = Application.Trim(cell.Value)
Next cell
On Error GoTo 0
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub


Gord Dibben Excel MVP