When we work in often Excel, we deal with numbers, texts, and date format. In Excel, the date & time are stored as numbers and converted to readable values based on the formatting. Here we will show the simple formula to convert the date into text format. Let’s begin!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- You can use the below formula to convert the calendar date into text format.
=TEXT(date,format)
Syntax Explanations:
- *TEXT * – In Excel, the **TEXT function **helps you to simplify things when you come across data that has too much text.
- *Date * – It represents the input dates from your worksheet.
- Format – It specifies which format you want to display your date.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Let’s consider the below example image.
- First, we will enter the input dates in Column B.
- Now we are going to get the date in text format (like 30/04/2021 as 30 April 2021).
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
Bottom-Line:
Hope you like this article on how to convert the date into text in Excel. Let me know if you have any doubts regarding this article or any other article on this site. Thank you so much for visiting. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)