Hi,
I want the cell (in which I type some numerical value) to show a certain percentage of the entered value (say 40 %) but in the same cell instead of actual value entered. For example if I type let say 100 in the cell A1, the same cell should now show a certain percentage of the entered value (say 30 or 40 % whatever required) instead of showing the entered value. Like in cell formatting, we can program the cells to show the entered values in different styles/ways but underlying actual value remains same.
Hello,
You need to play around creating some conditional rules to control what custom number format should be applied. I wonder of what good usage such scenario could be. Anyway, here is a good guide on how to play around with custom formatting.
https://www.myonlinetraininghub.com/excel-custom-number-format-guide
Br,
Anders
Of course this was posted in another forum as well.