Not as you enter it, unless you use VBA
However, it is easy to change a range of values after they have been
entered.
Suppose the range is A1:B10
In some empty cell (C1) type 100; Copy C1
Select A1:B10; use Edit | Paste Special and specify Divide
When done, you may delete C1
best wishes
Is the 65.26 a percentage? If so, you can format your cell(s) as
Percentage... then when you enter 65.26, it will display as 65.26%, but the
actual underlying value will be 0.6526 and that is the value that will be
used in calculations involving the cell(s).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
