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.