(Formatting a cell with decimal point numbers) You can change this behavior by changing the format template used for the cell that stores your decimal number. Notice that Excel changes the displayed value as '15' without the two zeros and the ending decimal point. If you type two zero decimal point numbers into a 'General' formatted cell, Excel 2019 automatically truncates the two zeros and displays only the whole integer number. You want to display money values with two decimal points. For instance, suppose that you're working with a financial spreadsheet. Excel has a number of pre-formatted templates that you can use to display numbers a specific way. It's common for users to work with Excel to track numerical data. This article covers the common format options that you can do with Excel. You can format cells with different borders, fonts, colors and numerous other styles. In addition to formatting the alignment for cells, Excel has several other ways to display content. Numbers are automatically formatted with a right alignment. String values (alphanumeric characters) are automatically formatted with a left alignment.

As you type content into an Excel spreadsheet, you'll notice that the software automatically formats it based on the input type.

Format date cells in excel