Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Turning Number Recognition On or Off in Tables

Office can automatically recognise numbers or dates that you enter into a table cell, converting them from text to an appropriate number format. Use Table - Number Format to change the display of the entered value.

When an input cannot be recognised as a number, the number category changes to Text and the input is not changed.

If Number recognition is not marked, numbers are saved in text format and are automatically left-aligned.

To enable or disable this feature, do one of the following:

  • Choose Table - Number Recognition.

When this feature is on, a check mark is displayed in front of the Number Recognition command.

  • Choose Tools - Options - Office Writer - Table, and select or clear the Number Recognition check box.

This feature applies globally to all tables in all documents. When enabled, typing a date or number into a table cell will result in automatic formatting. Enabling and disabling this feature does not change existing data formatting.