Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

A    78
B    79

How can I show only the last two digits of a number in LibreOffice Calc?

share|improve this question
up vote 3 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


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.