Libre Office Calc - How to format cells

Back

17-10-2018

(Click image above to watch video tutorial)

In this video tutorial, I will show you how to format cells in Libre Office Calc 6.

Spreadsheet cells can contain different types of information such as:

  • Dates
  • Number Values
  • Text Values
  • Percentages
  • Currency Values

It is important to understand how to format cell correctly in LibreOffice Calc.

When cells are formatted correctly the data entered will display in the correct format.

You can also change how data is displayed depending on the chosen format, for examples, currently, values may contain a "£" or "$" sign. 

Subscribe to DCP YouTube channel for more free Libre Office video tutorials.

Not familiar with open office Calc? - Check out of free extensive Cal spreadsheet tutorial.

Download Libre  Office:  https://www.libreoffice.org/

# LibreOffice spreadsheet cell formats

# How to format cells in LibreOffice

# LibreOffice spreadsheet cell formatting


Libre Office cell formatting tutorial created by: DCP Web Developers

 


Releated Posts

Open office 4 writer beginners tutorial

03-11-2013

Open office 4 writer beginners tutorial

This is a beginners video tutorial for Open Office Writer. In this video tutorial will take a look at Open Office 4 Writer. We will cover the fundamentals of Open Office 4 Writer to ensure you have a good understanding. Open Office 4 Writer is a free word-processing application which is very similar to Microsoft Word or Libre Office 4 Writer.

Libre Office Calc - Array Formulas and Functions - Part 1

02-11-2018

Libre Office Calc - Array Formulas and Functions - Part 1

In this video tutorial, I will show you how to use Libre Office Calc Array Formulas and Functions. Array Formulas and Functions can speed up the tasks when using spreadsheets. When you have to analyse data in a spreadsheet, Array Formulas and Functions can help proceed data more efficiently.

VAT Bookkeeping Tutorial - Small Business - Invoice Template - Part 2

08-06-2015

VAT Bookkeeping Tutorial - Small Business - Invoice Template - Part 2

This is a free VAT Booking Keeping Tutorial for small businesses. In this 2nd tutorial, we will focus on creating a VAT Invoice Template. Designing and invoice template can be a little bit tricky when you're not fully understanding all of the components required. In this tutorial, we will use OpenOffice Calc to design a custom VAT invoice template which you can reuse multiple times to send out invoices to your customers.

Libre Office 6 - Calc - Basic Formulas Tutorial

09-10-2018

Libre Office 6 - Calc - Basic Formulas Tutorial

In this video tutorial, I will show you how to use basic formulas in Libre Office Calc 6. Understanding how formulas work in spreadsheets can save you lots of time. You can use formulas to repeat processings like adding numbers together or create more custom complex formulas for data analysis.

GET YOUR FREE QUOTE


CLAIM YOUR 2 HOURS

FREE CONSULTANCY


  • AFFORDABLE PRICING
  • 15 YEAR KNOWLEDGE
  • LONDON BASED DESIGN AGENCY

NO OBLIGATION QUOTE

arrow
Please enter your name
Please enter correct email
Please enter your phone number
Please enter your message

Your data is encrypted and never shared.
View our privacy policy.

Thank you for contacting us.
We will reply to you in next 2 working days.

back