Select the option (Automatic, Number, and so on) you want to use from the pop-up menu. Numbers: Click the Format icon (the paintbrush) in the toolbar, then select the Cell entry in the resulting sidebar. Your cells will still be treated as numbers for use in calculations, but they will display with the defined text. For example, a format of #,#0.00 "widgets" would format your number with a comma if needed, two decimal places, and the word widgets after the number. The Custom option (recently added to Numbers as well) is especially useful, as you can combine text with your formatted number. All number formats are listed down the left edge of the dialog box select one, and its options appear on the right. You can also use the Format > Cells menu, then click Number in the dialog box that appears.
Excel: Many often-used number formatting options are visible in the Home ribbon.
0 kommentar(er)
