How to Convert Numeric Dates to Text on Google Sheets

This practical guide explains how to convert numeric dates to text on google sheets with clear steps and useful context. It also covers common requirements, potential problems, and the details that can help you get better results.

Convert Date Numbers to Words on Sheets Using the Format

Step 1:

In the cell or data area that you want to convert from numbers to letters , we highlight and then click Format, select Number .

Step 2:

Then we click on the custom Date and time setting at the bottom of the list.

Step 3:

Now display the custom interface of the time format. Now the user will choose the type of date display as text .

If you do not want to display any fields , then left-click and select Delete in the displayed list.

Finally click Apply to apply the new formatting style to the date.

As a result we will see the text format for the date on Google Sheets as shown below.

Convert Numeric Dates to Text Using the Text Function Google Sheets

In Google Sheets there is also a format conversion function for you to use. We will use the TEXT function with the formula =TEXT(value, format_text) .

In there:

• Value: Is the numeric value to be converted to text.
• Format_text: Is the format to use, providing the format of the format code enclosed in quotes, like "mm/dd/yy".

TEXT supports the following date and time patterns:

• d for the day of the month as one or two digits.
• dd for the day of the month as two digits.
• ddd for the short name of the day of the week.
• dddd for the full name of the day of the week.
• m for the month of the year as one or two digits or minutes in the hour. The month will be used unless the code includes hours or seconds as part of the hour.
• mm for the month of the year as two digits or minutes in the hour. The month will be used unless the code includes hours or seconds as part of the hour.
• mmm for the short name of the month of the year.
• mmmm for the full name of the month of the year.
• mmmmm for the first letter of the month of the year.
• yy for the year as 2 digits.
• yyyy gives the year as 4 digits.
• HH for 24-hour clock time.
• hh for 12-hour clock time.
• ss for seconds in an hour.
• ss.000 for milliseconds in an hour.
• AM/PM to show the time according to the 12-hour clock and indicate am or pm/evening depending on the time of day.

Note that date/time patterns and # or 0 cannot be combined.

First we have the date table below to apply the formula.

You enter the Text formula in the cell right next to it to convert it to text.

As a result, we get a string of dates in text as shown below.

Convert Numeric Dates to Text on Google Sheets with the QUERY. Function

The QUERY function in Google Sheets is used to filter data, and you can use this function to convert numeric dates to text.

The QUERY function formula is =QUERY(data; query; headers) .

In there:

• data: The range of the data range (eg 'Class A'!A2:E7).
• query: A query to output the desired data.
• headers: You can enter a value or leave it blank
• Usually has 2 values (0 or 1); 0 means no data header column name; 1 means get the title column name).
• If you leave it blank, the default headers will be 1.

We apply to the date column below with the input formula as shown.

=QUERY(C45:C47;"SELECT C FORMAT C'DD MMMM YYYY'").

We will select all the data of column C with the same selected data with the date format as shown.

When you press Enter, the entire selected data area will be converted to the text date format as shown below.

Conclusion

Understanding Convert Numeric Dates to Google Sheets makes it easier to compare options, avoid common mistakes, and apply the information in this guide more effectively. Review the relevant requirements before making changes or choosing a solution.