Autocalc not working

  • Thread starter Thread starter shazzbat
  • Start date Start date
S

shazzbat

When I select a group of cells, in most of my excel docs, the sum of those
cells is displayed in the bar at the bottom of the sheet.

In some docs, it doesn't work. I've right-clicked on the bar and sum is
checked, but nothing happens. Is this my fault? Most things are.

TIA

Steve
 
In those "some" docs, the numbers are probably entered/pasted as Text,
rather than numeric values.

To convert them, copy a blank cell, select your 'numbers' and choose
Edit/Paste Special, selecting the Values and Add radio buttons.
 
Not your fault entirely if the data is being imported.

Very common to have numerics come in as text in that case.

Just have to watch for them.


Gord Dibben MS Excel MVP
 
Thanks again, but I don't do importing, only very minor domestic stuff.
It's my fault, everything's my fault. Ask my wife if you don't believe me.
:-))

Steve
 
Back
Top