User level: Level 1 (4 points)Numbers error when dividing by a fractional value.
If format is changed to percentage the formula’s denominator changes.
Example: Enter .05 then divide any constant say 10 by that value then change format to percent and see theresult get reformatted to percent too. Is this a feature or a bug?
0.05
200
Change format only of the divisor and calculation changes format of formula result.
5%
20000%
Posted on Oct 12, 2026 7:46 PM
User level: Level 7 (22,545 points)Oct 12, 2026 8:45 PM in response to BerndtW
Hi BerdtW,
Both are correct. It is a feature. It depends upon your overall aim. I tend to work with numbers, and then if necessary, turn the final result into a percentage.
Happy Numbering!
Regards, Ian.
Originally posted at discussions.apple.com/thread/256375163