I have a spreadsheet like this in LibreOffice Calc:
1 2 A 012345678 Henry B 012345679 George
The first column displays some ID numbers.
I need to display a shorter form of this number in another column, showing only the last two digits. This would look like this:
3 A 78 B 79
How can I show only the last two digits of a number in LibreOffice Calc?