Given a result of a previous calculation, (always positive and > 1000) I want Excel to show in another cell just the units and tens of that result.
Let's say I have 22768.
I need Excel to show just 68 (not as text but as a numeric value).
The value 22700 is unknow beforehand thus no substraction possible.
Any idea how to obtain that?
Let's say I have 22768.
I need Excel to show just 68 (not as text but as a numeric value).
The value 22700 is unknow beforehand thus no substraction possible.
Any idea how to obtain that?