Do dating sites use 5 digit numbers updating web.config sharepoint
Because Error Checking in Excel can identify text-formatted dates with two-digit years, you can use the automatic correction options to convert them to date-formatted dates.
You can use the DATEVALUE function to convert most other types of text-formatted dates to dates.
If you import data into Excel from another source, or if you type dates with two-digit years into cells that were previously formatted as text, you may see a small green triangle in the upper-left corner of the cell.
This error indicator tells you that the date is stored as text, as shown in this example.
Use the following procedure to convert the text-formatted date back to a regular date.