![]() ![]() However, if you first format the cell as a date (for example, d/d/yyyy) and then type the number 36526, the cell displays. ![]() This is because the cell remains in the General number format. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526. With the General format, anything you type into the cell is usually left as-is. Number Tab Auto Number Formattingīy default, all worksheet cells are formatted with the General number format. The following sections describe the settings available in each tab. There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. The "More Information" section of this article provides information about each of the settings available in the Format Cells dialog box and how each of these settings can affect the way your data is presented. You can access and modify the majority of these settings in the Format Cells dialog box (on the Format menu, click Cells). For example, you can specify the number of digits to the right of a decimal point, or you can add a pattern and border to the cell. Microsoft Excel lets you change many of the ways it displays data in a cell. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |