In this post, we will discuss how to format cells in Microsoft Excel 2013. 1.Select the cells that you want to format. 2.Click the desired buttons in the “Font,” “Alignment” or “Number” button groups on the “Home” tab in the Ribbon. 3.How do I create a custom number format in Excel 2013?
If you go to the dialog box above, and click Custom in the Category box, you can then create a custom number formatting based on an existing number format in MS Excel 2013. In the Type list, select the format that you want to edit and edit it in the Type box. Click OK when you're finished.How do I create a conditional formatting rule in Excel?
Select the desired cells for the conditional formatting rule. From the Home tab, click the Conditional Formatting command. A drop-down menu will appear. Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears.What is the default format for numbers in Excel?
General is the default format for any cell. When you enter a number into the cell, Excel will guess the number format that is most appropriate. For example, if you enter 1-5, the cell will display the number as a Short Date, 1/5/2010. Number formats numbers with decimal places. For example, if you enter 4 into the cell]