Forum Discussion
Solved
Rounded Numbers
XL, by default, is returning rounded whole numbers, my column is set to "numbers." and decimal places to "7;" I need accuracy, how do I change this?
Thanks! The QUOTIENT function performs integer division, i.e. its result will always be a whole number. Use the / operator instead:
=C1/D1
Does the column contain formulas? If so, what do they look like?
HansVogelaar In E1 =QUOTIENT(C1,D1) w/coloumn set to number and 7 places
C=40 D=13 E= 3.0000000
Thanks! The QUOTIENT function performs integer division, i.e. its result will always be a whole number. Use the / operator instead:
=C1/D1
- Also, a relatively new computer with default setting in XL
- set all three columns to number with 7 places, still the same result.
