Type the formula =Value() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example, it’s cell A2 . Press Enter.

Microsoft Excel has a feature that allows you to convert a number into a date, which is quite simple to do. This tutorial explains the steps to convert a number into a date format in Excel.