But the underlying value won't change, and Excel will use the original value (0.5678) in all calculations. For example, if you type or 1/4, Excel will treat it as a date and change the cell format accordingly.Ī quick way to check the format applied to a certain cell is select the cell and look at the Number Format box on the Home tab, in the Number group:Īn 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.įor 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. There are situations when Excel may automatically change the General format to something else based on the value you input in a cell. But if you view the number in the formula bar, you will see the original number that you entered (25000000). For example, if you type a large number is a narrow column, Excel might display it in the Scientific notation format, something like 2.5E+07. In some cases, Excel may not display the cell value exactly as you've entered it, though the cell format is left as General.
With the default formatting, anything you input into a cell is usually left as-is and displayed as typed. By default, all cells in Microsoft Excel worksheets are formatted with the General format.
0 kommentar(er)
