I have a number in A1 (let's say it is
10). This represents the number of answers in a test.
In B1 I have the number of correct answers from the test (let's say this number is
In B1 I want to be able to type the number
6 and for it to display as
/10 bit being drawn from cell A1).
The value of the cell is still
6 only however. This is just for the visual effect and the actual cell can have formulas done on it and such.
If I select B1 and type the number
7 it should update visually as
Is this possible without fancy VBA stuff? Many thanks