What do you mean? The instructions which Gary''s Student gave you will put
your 3 numbers in 3 consecutive columns.
--
David Biddulph

"kyoshirou" wrote in message
...
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!