then all the values will become one only. rest of values r gone.

"Gary''s Student" wrote:

If you have a series of values in a single cell separated by ALT-ENTER, then
1. select the cell
2. Data Text to Columns Delimited Next Other
click in the box next to the Other checkbox
While holding down the ALT key, touch 010
Finish

This will split up the data into individual cells, then addition will be easy.
--
Gary''s Student - gsnu200745


"kyoshirou" wrote:

Hi,
If i have some numbers inside a column, means i enter value 5.8, then
Alt+Enter, i enter another value 6.0, then Alt+Enter, follow by value of 8.0,
etc

Can i calculate the Average or total of the sum in that single column anot?

coz if single value inside a single column, i can drag n calculate auto.

Any sugguestions?
Thanks!