Autocalc not working

[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

 

[JE McGimpsey]

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.

 

[shazzbat]

Right, thanks for that. See, I said it would be my fault )

Steve

 

[Gord Dibben]

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

 

[shazzbat]

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