In the Category drop-down list, select the category you want, such as currency, date, or text. The Number Format dialog box opens for you to set options for various categories of numerical data. Select the cells to format, then right-click and select Number Format from the pop-up menu. Number recognition can be set on or off under Tools > Options > Writer > Table. If n umber recognition is not selected, numbers are saved in text format and are automatically left-aligned. ![]() Number recognition specifies that numbers in a text table are recognized and formatted as numbers. ![]() For example, cells can be set to display in a particular currency, to four decimal places, or in a particular date format. The number format can be set for a whole table or group of cells.
0 Comments
Leave a Reply. |