In a LibreOffice spreadsheet, I want to display numbers (actually, prices) with two decimals. When a cell contains just a number, I can format it to do automatic padding.

But sometimes I have cases where I concatenate strings, like this:

Image says it all, I guess. Is there a function or expression to pad a string or number, rather than doing this through a cell's formatting properties?

  • 1
    Excel has a TEXT function which does exactly what you need. I don't know libreoffice, but suppose it has something similar too. May 26, 2016 at 8:29
  • 1
    @MátéJuhász thanks, I got it working with FIXED but I noticed TEXT is even more versatile.
    – RocketNuts
    May 26, 2016 at 9:02

1 Answer 1


Solved! I couldn't find this it at first, but I've got it: FIXED(C1,2)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .