My autosum total is incorrect - what is wrong?

  • Thread starter Missing the obvious?
  • Start date
M

Missing the obvious?

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?
 
G

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
 
Top