Instructions for Reading Axessors Serial Numbers

Reading Axessors Serial Numbers

Axessors however follow a different rule, simply take the first five (5) digits of the serial number, copy it into a Microsoft Excel cell and format the cell to date

Example: 4381937403074

Convert a serial number to a date using the first five digits in Microsoft Excel

Steps:

1. Extract the first five digits: From your serial number, identify the first five digits. For example, if your serial number is 4381937403074, the first five digits are 43819.
2. Enter the digits into an Excel cell: Open your Microsoft Excel spreadsheet and type the first five digits of the serial number into a cell.
3. Format the cell as a date: Right-click on the cell containing the digits.
4. Select Format Cells... from the context menu.
5. In the Format Cells window, click on the Number tab.
6. Under the Category list, choose Date.
7. (Optional) You can select a specific date format from the Type list below. If you don't choose a format, Excel will use its default date format.
8. Click OK to apply the formatting.

The cell should now display the date equivalent of the first five digits of your serial number.

Applies To

Axessor