Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating Problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating Problem
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 "Dave" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating Date problem | Excel Discussion (Misc queries) | |||
formating problem, PLEASE help. | Excel Discussion (Misc queries) | |||
Chart formating problem | Charts and Charting in Excel | |||
numbers formating problem | Excel Discussion (Misc queries) | |||
Currency formating problem | Excel Discussion (Misc queries) |