Column A is formatted as a percentage, with 4 decimal places.
When I enter 5 or .05, I get the same result (5.0000%).
This is obviously not correct.

If the rule is to multiply the number entered by 100, then 5 should be
500.0000% and .05 should be 5.0000%.

So what's wrong here, and how do I make sure that users (and me), don't
enter the wrong values?

Thanks,
Bernie