E
Edelmundo
has anyone come accross an anomaly like this before ?
I have a spreadsheet the has a 2 cells that have been merged i have no
mergered the cells i received the spreadsheet with the cells alread
merged, both cells contain a value. One contains the value 40 and th
other 65. When the merged cell is clicked the sum view in the botto
right of the window shows the value as 105.0 I have read o
microsoft's site etc that when cells containing data are merged the th
value is taken from the top left cell and the other data is "deleted"
this has not happened with this merge. If i unmerge the cell and the
remerge the cell then the cells are merged correctly and the sum doe
not show 105 as the values have been discarded.
I cannot replicate the incorrect merge ??
:confused
I have a spreadsheet the has a 2 cells that have been merged i have no
mergered the cells i received the spreadsheet with the cells alread
merged, both cells contain a value. One contains the value 40 and th
other 65. When the merged cell is clicked the sum view in the botto
right of the window shows the value as 105.0 I have read o
microsoft's site etc that when cells containing data are merged the th
value is taken from the top left cell and the other data is "deleted"
this has not happened with this merge. If i unmerge the cell and the
remerge the cell then the cells are merged correctly and the sum doe
not show 105 as the values have been discarded.
I cannot replicate the incorrect merge ??
:confused