Padding Numbers In the previous example you saw that we can format numbers and force then to display a fixed number of decimal places. The 0.00 part of the custom format makes this happen. For example ...

Since Excel's primary function is to handle numerical data, the General number format displays numbers exactly as they are typed without any formatting.