Formating Problem

[Dave]

I am working on a large spread sheet. Occasionally, it is necessary insert
rows through columns which have already been formatted. Typically, some
columns are totaled (summed) at the bottom. In the past, I have
occasionally noticed (I think) that the sum of a column which has had a row
inserted is incorrect if the inserted row is not formatted before a value is
placed in it. The value is generally place by dragging a logic function
into the cell.

Not sure I'm explaining this clearly, but does any of this make sense?

If, indeed, that is what I have done (to quite a bit of data), is there any
way to reformat a cell, that has had a function dragged into it, so that
it's contents will contribute to the various totals? In fact, do I even
have to do that?

Thx

Dave

 

[Dave]

Progress Report

I have discovered if I have a long column of numerical values where I know
the sum is incorrect, if I Copy/Paste/Special/Values the same numbers right
back in the same place, the total is now correct. This was on a column
which only had numerical values. Many of them are formulas, however. Is
this going to work on those columns?
Thx
Dave