excel font size must be between 1 and 409 border

To see the underlying value behind the number format, select a cell and look at the formula bar:

Similarly, you can change the display representation of date and time values the way you want, but Excel will keep the original value (serial numbers for dates and decimal fractions for times) and use those values in all Date and Time functions and other formulas. 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.

Excel font size must be between 1 and 409 border