Modify Number Form For Free

Available number formats in Excel Select a cell or a cell range. On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells? , and select Number. ... Select the format you want.

If the standard number formats don't meet your needs, there are additional format options to select from. Select the cell(s) that contain values you want to format. Click the Number Format list arrow from the Home tab. Select More Number Formats. ... Select a Category. Specify the formatting options. Click OK.

Format numbers Select the cells containing the numbers you need to format. Select CTRL+1. ... In the window that displays, select the Number tab (skip this step if you're using Microsoft 365 for the web). Select a Category option, and then select specific formatting changes on the right.

An important thing to remember is that formatting cells in Excel changes only the appearance, or visual representation, of a cell value but not the value itself. For example, if you have number 0.5678 in some cell and you format that cell to display only 2 decimal places, the number will appear as 0.57.

Format numbers, dates, and currencies On your Android phone or tablet, open a spreadsheet in the Google Sheets app. Tap a cell or range of cells. Tap Format. . Tap Cell. Number format. Tap an option from the list. The format will be applied to your selected cells.

Apply a custom number format Select the cell or range of cells that you want to format. On the Home tab, under Number, on the Number Format pop-up menu. , click Custom. In the Format Cells dialog box, under Category, click Custom. At the bottom of the Type list, select the built-in format that you just created. ... Click OK.

Select the cells that you want to format. On the Home tab, in the Number group, click the dialog box launcher next to Number (or just press CTRL+1). In the Category list, click the format that you want to use, and then adjust settings, if necessary.