Turning Number Recognition On or Off in Tables

LibreOffice can automatically recognize 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:

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.

- LibreOffice Writer - Table

Please support us!