# How to Convert Serial Number to Date in Excel?

When you enter dates into an Excel sheet, you may notice that the date is displayed as a number. So, we need to convert them into dates. In this article, we will learn how to convert a serial number to a date in Excel. We can solve this problem by using two methods: the first is by using the format, and the second is by using the formulas supported by Excel.

In Excel, every row has a serial number connected to it. Here we will use two methods to complete the task: the first is by using the format function, and the other is by using the formula.

## Converting Serial Number to Date Using Format

Here, we will first select the data and then use the format to complete the task. Let us look at a simple procedure for converting a serial number to a date in Excel using a format.

### Step 1

Let us consider an Excel sheet where the data in the sheet is similar to the data shown in the below image. Now select the data, then right-click and select format cells; in the popup, click on date, choose format, and click OK.

Select data > Right click > Format cells > Date > Format > OK/ ## Converting Serial Number to Date Using Formulas

Here, we will first use the TEXT formula to get any one of the results, then use the auto-fill handle to get all the results. Let's go over a simple procedure for converting a serial number to a date in Excel using formulas.

### Step 1

Let us consider the same data that we used in the above example.

Now click on the empty cell in our cell B2 and enter the formula as =TEXT(A2,"m/d/yyyy") and click enter to get our first result. In the formula, A2 is the address of the cell value in the sheet.

Empty cell > Enter formula > Enter ### Step 2

To get all the results, drag down from the first result using the auto-fill handle, and our final result will be similar to the below image. ## Conclusion

In this tutorial, we used a simple example to demonstrate how you can convert a serial number to a date in Excel.

Updated on: 06-Mar-2023

185 Views 