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