Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

If cell A2 contains 012345678, then to get 78 to display in cell D2, enter =right(A2, 2) in cell D2.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.