![]() ![]() If the built-in number format doesn't meet your needs, you can create your own custom number format. If you want to type non-calculated values such as 10e5, 1 p, or 1-2, and you do not want Excel to convert the value to a built-in number format, you can apply the Text format to the cells, and then enter the number. For example, if you type a number that contains a slash mark (/) or hyphen (-), Excel may interpret it as a date and convert it to date format. However, Excel occasionally applies an unexpected number format, and you may have to make some adjustments as a result. Most of the time, numbers display the way you intend them to, whether you enter them in the worksheet or import them from a database or other external source. You can also drag the right boundary until the columns are the size that you want. This automatically resizes the column to fit the number. To expand the column width, double-click the right boundary of the column that contains the cells with the # error. If Microsoft Excel displays # in a cell after you apply number formatting to it, the cell probably isn't wide enough to display the data. ![]() For example, if you're using the Currency format, you can select a different currency symbol, show more or fewer decimal places, or change the way negative numbers are displayed.įor more information about number formats, see Available number formats. In the Category list, click the format that you want to use, and then adjust settings, if necessary. On the Home tab, in the Number group, click the dialog box launcher next to Number (or just press CTRL+1). Select the cells that you want to format. For example, if you're working on your quarterly budget, you can use the Currency number format to show monetary values. By applying different number formats, you can display numbers as percentages, dates, currency, and so on. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |