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.

Excel has a surprising limitation that you may not discover until you try to enter more than 15 digits in a cell. The application can only store numbers with15 digits of precision.