atferrari
Full Member level 4
- Joined
- Jun 29, 2004
- Messages
- 237
- Helped
- 7
- Reputation
- 14
- Reaction score
- 3
- Trophy points
- 1,298
- Location
- Buenos Aires - Argentina
- Activity points
- 1,996
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?
Added after 1 hours 31 minutes:
Problem solved, gentlemen.
MOD function (RESIDUO in Spanish).
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?
Added after 1 hours 31 minutes:
Problem solved, gentlemen.
MOD function (RESIDUO in Spanish).