Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Formatting numbers

Several number formats can be applied to cells by using icons on the Formatting toolbar. Select the cell, then click the relevant icon.

Calc number formats
Number format icons. Left to right: currency, percentage, date, exponential, standard, add decimal place, delete decimal place.

For more control or to select other number formats, use the Numbers tab.

  • Apply any of the data types in the Category list to the data.
  • Control the number of decimal places and leading zeros.
  • Enter a custom format code.

The Language setting controls the local settings for the different formats such as the date order and the currency marker.

Format Cells > Numbers

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire