excel formulas(sum,average etc) not working, always giving 0

February 10, 2015 at 21:25:42
Specs: Windows XP
if there is a space after your number, it will be considered text and not number and calculations are performed only on numbers, whether that be sum formula , average or any other..
so do check that your numbers do not have a space at the end, it generally happens when you copy and paste numbers from some source

See More: excel formulas(sum,average etc) not working, always giving 0

Report •


#1
February 11, 2015 at 04:19:41
Thanks for the tip.

It gets even more interesting when dates are involved. Dates from outside sources will often end up as text and even formatting the cell as a Date doesn't mean that Excel will recognize the data as a Date.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question