This page describes the following three different methods, that can be used to convert a date to text in Excel.
|Excel Convert Date to Text Index:|
|Date to Text By Adding an Apostrophe|
|Date to Text Using Text to Columns|
|Date to Text Using Excel Functions|
The quickest way to convert an Excel date to text is to insert an apostrophe in front of the date (see rightabove).
The apostrophe will not be displayed in the cell, but it will tell Excel to treat the contents of the cell as text.
If you want to convert an entire column of Excel dates to text, you might prefer to use the Excel Text to Columns command.
However, note that the Text to Columns command only works on one column of data at a time.
To use the Excel Text to Columns command to convert dates to text:
From the Data tab on the Excel ribbon, select the Text to Columns option (see rightabove).
You should now be offered a selection of Column Data Formats. Select Text and click the Finish button.
The Excel Text Function converts a supplied numeric value (including an Excel date or time) to text, using a user-specified format.
The syntax of the function is:
The spreadsheet below shows examples of the Excel Text Function used to convert the date 01/01/2016 into text strings with various date formats: