My autosum total is incorrect - what is wrong?

[Guest]

I'm doing a basic formula - about 400 entries to tota. I used autosum and my
total is incorrect. Is there a way to figure out if these cells are
formatted as text and therefore not being read?

 

[Gord Dibben]

In an adjacent column enter =ISNUMBER(cellref)

Copy down.

Or without checking first you can format all as General.

Copy an empty cell and select the data and Edit>Paste Special>Add>OK>Esc.

This should turn any text to numeric.


Gord Dibben MS Excel MVP