How to Convert the Date to Text in Excel

1. Open in Excel the workbook that has the dates you want converted to text. If that file isn't available, populate date data into a single column (A2) in a new Excel workbook.
2. Label your date column (presumed to be column A for purposes of this instruction) as 'Date' in cell A1. Label the column where you want the converted date to populate as 'Date-Text.'
3. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mmm-yyyy format:=TEXT(A2,'dd-mmm-yyyy')Example:
Date: 1/10/2010
Date-Text: 10-Jan-2010Copy this formula down the column as necessary to convert all of the date data to text data.
4. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mm-yyyy format:=TEXT(A2,'dd-mm-yyyy')Example:
Date: 1/10/2010
Date-Text: 10-01-2010Copy this formula down the column as necessary to convert all of the date data to text data.
5. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mmm-yy format:=TEXT(A2,'dd-mmm-yy')Example:
Date: 1/10/2010
Date-Text: 10-Jan-10Copy this formula down the column as necessary to convert all of the date data to text data.
6. Enter the following formula in the second row of the 'Date-Text' column to convert the date to mmm-dd-yyyy format:=TEXT(A2,'mmm-dd-yyyy')Example:
Date: 1/10/2010
Date-Text: Jan-10-2010Copy this formula down the column as necessary to convert all of the date data to text data.
7. Enter the following formula in the second row of the 'Date-Text' column to convert the date to mmm-dd-yy format:=TEXT(A2,'mmm-dd-yy')Example:
Date: 1/10/2010
Date-Text: Jan-10-10Copy this formula down the column as necessary to convert all of the date data to text data.