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 Writer User Guide
Previous Page Home Next Page

Number formats

The number format can be set for a whole table or group of cells. For example, cells can be set to display in a particular currency, to four decimal places, or in a particular date format.

Number recognition specifies that numbers in a text table are recognized and formatted as numbers. If number recognition is not selected, numbers are saved in text format and are automatically left-aligned. Number recognition can be set on or off under Tools > Options > Writer > Table.

Select the cells to format, then right-click and select Number Format from the pop-up menu. The Number Format dialog box opens for you to set options for various categories of numerical data.

  • In the Category drop-down list, select the category you want, such as currency, date, or text.

  • In the Format drop-down list, choose a format for the category you just selected.

  • For some categories, such as date, you may wish to change the language using the Language list.

  • Additional options are available for different categories.

OpenOffice Writer User Guide
Previous Page Home Next Page

  Published under the terms of the Open Publication License Design by Interspire