C
César
Hello all.
I comment you a strange thing that makes my Excel (Office 2003 SP2).
(Perhaps is a piece of nonsense and I have reinvent the wheel)
In the range ‘A1:A10’ of an empty worksheet I write several values
(1,2,3,4,5,6,7,8,9,10).
In the cell ‘A11’ I put `=Average(A1:A10)'. (Result = 5.5)
I select the range ’B1:B10’ and with `Format - Alignment', I combine the
cells.
I copy the combined range ‘B1:B10’ and in A1 I made a Special Paste - Format
(if I combine A1:A10 directly does not work)
The range ’A1:A10’ is combined and shows the value that was in A1 (1) but it
conserves hidden the values of all the cells: The formula of the average
continues showing correct value 5.5. If in another cell I put for example
'=A4' shows the correct value (4); and if with `Format - Alignment' I
eliminate the combination of cells of ‘A1:A10’ appears all the initial values
again.
It works as much with vertical combinations as horizontal.
Somebody had been noticed of this?
Greetings, César González.
I comment you a strange thing that makes my Excel (Office 2003 SP2).
(Perhaps is a piece of nonsense and I have reinvent the wheel)
In the range ‘A1:A10’ of an empty worksheet I write several values
(1,2,3,4,5,6,7,8,9,10).
In the cell ‘A11’ I put `=Average(A1:A10)'. (Result = 5.5)
I select the range ’B1:B10’ and with `Format - Alignment', I combine the
cells.
I copy the combined range ‘B1:B10’ and in A1 I made a Special Paste - Format
(if I combine A1:A10 directly does not work)
The range ’A1:A10’ is combined and shows the value that was in A1 (1) but it
conserves hidden the values of all the cells: The formula of the average
continues showing correct value 5.5. If in another cell I put for example
'=A4' shows the correct value (4); and if with `Format - Alignment' I
eliminate the combination of cells of ‘A1:A10’ appears all the initial values
again.
It works as much with vertical combinations as horizontal.
Somebody had been noticed of this?
Greetings, César González.