Excel Guides

Incrementing Numeric Portions of Serial Numbers in Excel

You can increment numeric portions of serial numbers in Excel by using the following steps:

  1. First, select the cells that contain the serial numbers. You can do this by clicking on the cell, then holding down the Shift key and clicking on the last cell in the range. This will highlight all of the cells in between.
  2. Next, right-click on one of the selected cells, and choose Format Cells from the context menu that appears.
  3. In the Format Cells dialog box, select the Number tab.
  4. Under Category, choose Custom. This will bring up a text box labeled Type. In this box, type in the following:

[$-en-US]yyyy\MM\dd\ hh:mm:ss;@

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.