Turning Number Recognition On or Off in Tables /text/swriter/guide/number_date_conv.xhp number formats; recognition in text tables table; recognizing number formats numbers; automatic recognition in text tables tables; date formatting table cells; date formatting dates;formatting automatically in tables recognition;numbers

Turning Number Recognition On or Off in Tables

$[officename] 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.

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 %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME 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.

%PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Writer - Table