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.
Syntax:
Syntax
| 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
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.
