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 ...

How to Increment a Number in Excel. Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point.