How to Convert Date to Text in Excel (Explained with Examples)

Date and Time in Excel are stored as numbers. This enables a user to use these dates and time in calculations. For example, you can add a specific number of days or hours to a given date.

However, sometimes you may want these dates to behave as text. In such cases, you need to know how to convert the date to text.

In this tutorial, you’ll learn three ways to convert date to text in Excel:

1. Using the Text Function
2. Using the Text to Column feature
3. Using Copy Paste method

TEXT function: Text function is best used when you want to display a value in a specific format. In this case, it would be to display the date (which is a number) in the date format.

TEXT to COLUMN: If you’re not a fan for Excel formulas, there is another cool way to quickly convert date to text in Excel – the Text to Column feature. You can folow the steps in the video to use the 3 steps wizard to convert date to text.

COPY PASTE: In this method, you can simply copy the dates in notepad, format the cells in Excel to text format and copy the text from notepad back to Excel.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[theoriginalsbk]

You're a life saver. Been looking for this formula for the longest time.

[sonnyuntung]

your english is clear for Hindi dialect I've ever known... 4 Thumbs, thanks

[bayoubelle]

Thank you! I was searching the web for SOO long looking for this answer!

[ryanhoyle]

Dude... The notepad saved me! I multiplied x1 once I put back into Excel and got what I needed. You just saved me hours!

[tymothylim]

Thank you very much for this video! It was very simple and quick to understand!

[johnsonmshiu]

Bro you have saved my life today. Great job

[ezhankhan]

Perfect, this helped me out tremendously
- thank you!

[mariafriend]

Thank you, just what I needed. It’s difficult working with dates.

[futilityatitsbest]

You explained it so clearly! Thank you!

[KumarKumar-ghql]

Thank you for the great explanation...

[ericgottlieb]

Exactly what I was looking for! Thank you so much!

[hsildpr]

Needed this so badly. You saved me hours of work

[cedb]

thank ytou. Exactly what i am looking for

[loganatorstudios]

OMGOSH you saved me tons of work, thank you!!

[tllwrcm]

You are amazing and I learned a lot from you

[jjjonasification]

Thank you! Somehow the first method does not work for me, however, the 'Text to columns' method worked perfectly!

[puneetvij]

Sumit Bansal,
Thanks! Very useful. ; )

[ormancadam]

how to do reverse? 26/6 is keep converting to 45103 when I try to make it a text.
I only want 26/6 in text format. better I want it like 26, 6

[TheUpendraChaubey]

Thanks for the useful info but I want to convert the Date into Words i.e. 24-08-1988 as Twentyfourth August Nineteen Eighty Eight. How would I do this?

[aslammohammed]

Hi guys i need one result, i just type today date in cell and change to date to hijara Arabic date so i need upload to calendar thus its shows date which put as input(today date) i need there to display result ie, hijara date so guys help me out...