Format Cells In LibreOffice Calc

By | October 17, 2017

LibreOffice Calc allows you to format cells in any type without changing its value. You can change a value “0.5” to “50%” or “$0.5”, or change the appearance of the cell itself.

Formatting Calc Cell

Type any number in any cell of Calc.

By default Calc uses default number format when you type a number in a cell. To format the number, right click on the cell and select “Format Cells”.

Format Cell Option in Context Menu

Format Cells - Main

On the Format Cells dialog, choose category as Currency, Format as USD $ (Or anything you want), select desired formatting in format list. You can also choose number of decimal places, leading zeros you want. Once you are satisfied by looking at the preview, press OK.

SEE ALSO:  Count Cells with Strings, Numbers Using COUNTIF Function - Calc


To change the above number to %, you can click the % icon in the toolbar after selecting the cell. Calc provides common number formats in the toolbar itself for easy access.

Percent in Toolbar


Use Borders, border style, Font Color and allignment from toolbar to give the cell a different look:

order Styles in Toolbar Borders in Toolbar Color Palette in Toolbar

Once it is applied to the cell, it would look like this:


Next Chapter   Find and Replace

For the latest tutorials, news and how-to guides, follow on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 568 other subscribers.