If you type 5.555, it will display as 5.56.ĭigit placeholder that leaves a space for insignificant zeros on either side of the decimal point but doesn't display them. If you type 5.5 in a cell, it will display as 5.5. That is, if a number doesn't need a certain digit, it won't be displayed. If you type 5.5 in a cell, it will display as 5.50.ĭigit placeholder that represents optional digits and does not display extra zeros.
Codeĭigit placeholder that displays insignificant zeros.
How to create a custom number format in Excel