Those values aren't really numeric. They're text entries that just use
numerals.

If you have any choice at all in the layout of the data, put each number in a
different cell.

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!

--

Dave Peterson