WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to convert date to text format in excel

August 18, 2022
4.0K Views

When using Excel, we frequently work with date format, text, and numbers. Excel is exclusively an application for numbers that teaches us how to convert date to text format. The formatting that you provide will be used to display the values. For instance, the date and time are kept as numbers in Excel and are formatted to display legible values.

If you want to learn how to convert date to text in excel, you can scroll down and follow the following steps.

How to convert date to text in excel online, 2016 and 2019: 

1.Take a look at the sample below; cell A1 contains the value 43388. If we format the data as a date, it will appear as 15-10-2018.

2.When you right-click on the cell, choose Format Cells from the context menu.

3.Choose the date from the options shown below.

4.The outcome will now be shown as shown below.

5.Excel will display the numbers with the formatting that we provide as a result.

How to convert date to text using text function in excel:

1.Dates will be created from the integers in cells A2 to A10 below and placed in cells B2 to B10.

2.Enter the following formula in cell B2 to change them to date format.=TEXT(A3,”dd-mm-yyyy”)

3.Enter the formula by typing and dragging.

Using the Text to Column option, convert dates to text in excel:

1.To convert dates to text format if we don't like mathematics, we can utilise Excel's TEXT TO COLUMN OPTION. Assume that cells A2 to A8 contain data.

2.It must immediately be converted to text format.Before we can alter a column, we must first select the entire column.

3.Then, in Excel, select Data > Convert Text to Columns Wizard.

4.Before continuing to step 3, the delimiter must be chosen.In the freshly opened pop-up window, uncheck each box, then click Next to continue.

5.The following dialogue box requires that the TEXT option be chosen. Click Finish after entering =$B$2 in the target cell's value.

6.As a consequence, it will immediately change to text format.

Where in Excel can you convert a date to text:

1.Let's now have a look at some date conversions in Excel text.Excel's TEXT function must be used to convert a date to text. Excel stores time and date as numeric values, as was already described. However, occasionally we might have to display it as a text string. The TEXT function can be used in these circumstances.

VALUE and FORMAT TEXT are the two parts of the TEXT function.Value: What has to be converted is the value. Only the selected cell is present. It could be either a numerical value or a reference cell.Text is transmitted to the cell, or the destination cell, in the specified format.

Note: This above written article is an attempt to show you how to convert date to text format in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                  

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.