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
hy
OK Hans, that works, thanks so much, have a great day.