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???
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" <darnocnad@discussions.microsoft.com> wrote in message
news:98A4888D-5B8D-4770-BF3B-FB31CFF22E5C@microsoft.com...
> 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???
Question
Reply
Top
Answer
Notify me of replies