I tried to find out the mean of a set of numbers by using the "average"
function. But I got a zero as the result of averaging those numbers when I
know for a fact the mean should not be zero. I found the old post below and
did what was suggested thereof, but that did not fix the problem. Does
anyone know what is going on? Thanks.
************

Your numbers are text. Format the cells for general, then enter a 1 into a
blank cell. Copy that
cell, select your cells with your text-numbers, right-click and select paste
special, and choose
multiply. Then click OK, and all your values should become numbers.

--
HTH,
Bernie
MS Excel MVP


"darnocnad" wrote in message
...
Using Excel I have a list of numbers, if i use the add function it will add
them in a normal manner however, when trying to use the sum or average
function it sums to zero and the average is reported as div/0 . I have
tried to paste as values and repeat with the same result, any idea what is
going on here???


--
..