Convert xls serial number

Select the date cells, and right click to display context menu, select Format Cells. Click OK. Now the date in formula will be displayed as serial number. This utility can help you convert serial numbers to year, month, day, or mm-dd-yyyy or other formats. In the Apply Date Formatting dialog, select the date format you want to apply in left pane, then you can preview the result in right pane. Here I have a kind add-in—Kutools for Excel introduce to you, its Convert to Date utility can do you a favor.

Now the dates have been converted to standard date format. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? In this tutorial, we will see three ways to convert a serial number to date format in Excel. Excel stores date in the form of integers or serial numbers. The serial starts from January 1, , and increases by 1 for each day since then. That means January 1, , has the serial 1, the next day has the serial 2, and so on.

In this way, the serial for June 1, , is , because it is exactly 43, days after January 1, We will use the above three methods to convert these serial numbers to dates in different formats. The TEXT function in Excel converts any numeric value like date, time, and currency into text with the given format.

We can use this function to convert our serial number to any date format. The format code will depend on the format that you want your converted date to appear. Here are some basic building blocks for the format codes that you can use:.

Convert XLS 2. Convert serial number to date with formula. You can also convert serial number to date with formula in Excel. Please do as follows.