Spread the loveExcel is a powerful tool that enables you to organize vast amounts of data with great ease. However, if the data you are working with contains dates and they are in text format, it may ...

How to Convert Dates Stored as Text Into Dates. Working with large Excel files is sometimes a daily task when you run a small business.

I have a column which I believe have dates in text. I would like to convert them in to proper date, ie DD-MM-YY.

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.