In Excel, if a cell is formatted as "%" then you enter a number, you enter it as the "percent" value not the "decimal" value:
User types: "12"
Cell shows: "12%"
Decimal value: 0.12
This then means you can do something like
=A1 * A2 and get something meaningful.
Our cell settings are as follows:
pattern: '0 %'
In HOT typing 12 displays as "1200 %" which is undesirable.
I'd like for our users to be able to type "12" and see "12 %".
Perhaps I have to use a different kind of formatting?
Also, I assume I need to use
beforeChange() to parse this value to a number?