How to Convert date to text in Excel

In this article, we will understand how to use Excel text function to convert Date to Text in Excel.

Date & Text are different formats of Excel. Excel stores date with corresponding serial number. While calculating dates with numbers it gives a result, so we will convert Date into Text to avoid the above mistake.

The TEXT function lets you change the way a number appears by applying to format to it with format codes.

=TEXT(value, format_text)


Format Format_text
d 7
ddd Thu
dddd Thursday
m 2
mmm Feb
mmmm February
mmmmm F
yy 19
yyyy 2019
m/d/y 2/7/19
mm/dd/yy 02/07/19
mm/dd/yyyy 02/07/2019
ddd, mmm d Thu, Feb 7
mm/dd/yyyy h:mm AM/PM 02/07/2019 2:15 PM
mm/dd/yyyy hh:mm:ss 07/02/2019 14:15:00

Use the formula:


As you can see the value in the output cell is in Text format.
You can use any Format_text and do your work in excel without any interruption

Hope you understood how to change the formatting of Date to Text in Excel. Explore more articles on Excel Formatting styles. Please feel free to mention your queries in the comment box below. We will assist you.

Related Articles:

How to Convert Text to Number in Excel

How to Convert Date and Time from GMT to CST in Excel

How to Convert numbers to text in Excel

How to Convert month name to serial number in Excel

How to Convert negative number to positive number in Excel

How to convert decimal Seconds into time format in Excel

How to Convert Time to Decimal in Excel

How to Convert Excel Column Number To Letter

How To Convert Column Letter to Number in Excel

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.