In Reply to Parent Post by dbulak
I am adding numbers in Excel. I want the average, but Excel is rounding the numbers up to the next decimal. I have looked, but I just can't seem to find the fix. Anyone know what to do?
Thanks in advance.
Highlight the cells in question, right-click and choose Format Cells. Click the Number tab and then choose the number of decimal places you want. Excel always stores numbers in full precision regardless of the number of decimal places displayed. For example, if .1234 is rounded to .12, .1234 is still used in calculations.