Display the 0 at end of value (Libre Office Calc)

When I’m creating number values in a column, in Libre Office Calc, the 0 number is hidden from the view, if it is at the very end of the number. I’d like to see all of the numbers, even if the last number is a 0. Is there any way to do this?


  • What I want it to display, and what I type in: 16.80

  • What is displayed after typing in the number: 16.8

Asked By: Ryan King Art


Select the cell or cells you want to adjust.

If you’re handling numbers and need to be able to treat the values as numbers,

  • Format cells:
  • Numbers
  • Category: Number
  • Options: Decimal places: 2

If the numbers are actually text (phone numbers, perhaps) then,

  • Format cells:
  • Text
Answered By: roaima
Categories: Answers Tags:
Answers are sorted by their score. The answer accepted by the question owner as the best is marked with
at the top-right corner.