View Categories

How can I convert a text string into a date in Excel?

< 1 min read

  1. Step One: Open Excel and format the text string into a suitable format. To do this, select the cell containing the text string and go to Format Cells in the Home tab.

  2. Step Two: In the Number tab, select Date from the list of categories.

  3. Step Three: From the available list of formats, select the preferred one.

  4. Step Four: Click on OK to apply the formatting. The text string should now appear as a date in Excel

Powered by BetterDocs