{"id":9308,"date":"2025-12-12T14:32:32","date_gmt":"2025-12-12T14:32:32","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=9308"},"modified":"2025-12-12T14:47:34","modified_gmt":"2025-12-12T14:47:34","slug":"convert-text-to-date-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel","title":{"rendered":"How to Convert Text to Date in Excel? [6 Easy Ways]"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong><em>Want to know how to convert text to date in Excel sheet? If so, do not fret, you are reading the correct webpage. <\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">Converting text to date format in Microsoft Excel can be a challenging task. However, there are some easy ways available in this post that can assist you in the conversion process. So, let\u2019s check out this guide to convert text strings into proper Excel dates without errors.<!--more--><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix Excel file &amp; recover its worksheet data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>Why Text-to-Date Conversion in Excel Important?<\/strong><\/h2>\n<p style=\"text-align: justify;\">As we all know, Microsoft Excel stores dates as serial numbers. When dates stay in text format, then sorting &amp; filtering process fail and formulas in the spreadsheet also break.<\/p>\n<p style=\"text-align: justify;\">Hence, changing the text to date format is vital as it enhances the data accuracy, avoids calculation mistakes, and save time during data analysis.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Convert Text to Date in Excel Sheet?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Follow the steps below to convert text to date in Excel with a formula or without a formula.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<h3 style=\"text-align: left;\"><strong>Quick Navigation:<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Use the Text to Columns Feature<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Using Flash Fill <\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Change Text Strings to Date Using DATEVALUE<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Apply the Custom Date Formats<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Use VALUE Function<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">Using Power Query<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 1- Use the Text to Columns Feature<\/strong><\/h3>\n<p style=\"text-align: justify;\">The <strong>Text to Columns<\/strong> is an excellent feature in Excel that splits &amp; reformats text into dates created on delimiters or date recognition.<\/p>\n<p style=\"text-align: justify;\">Here is how you can use this tool for the conversion process:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Select the cell(s) that hold text dates.<\/li>\n<li>Next, go to the <strong>Data<\/strong> tab &gt;&gt; <strong>Text to Columns<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6792 \" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-1024x356.png\" alt=\"Excel Sum Formula Not Working Returns 0\" width=\"800\" height=\"278\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-1024x356.png 1024w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-300x104.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-768x267.png 768w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1.png 1052w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Click on <strong>Delimited<\/strong> &gt;&gt; hit <strong>Next<\/strong>.<\/li>\n<li>Proceed without selecting any delimiter.<\/li>\n<li>Now, pick <strong>Date<\/strong> in a Column Data Format.<\/li>\n<li>Select the accurate order like <strong>DMY<\/strong> or <strong>YMD<\/strong> &gt;&gt; hit <strong>Finish<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6793 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-2.png\" alt=\"Delimited\" width=\"507\" height=\"417\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-2.png 507w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-2-300x247.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<p style=\"text-align: justify;\">You are done!<\/p>\n<p style=\"text-align: justify;\">In case this method fails, try the further techniques.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\">How to Convert Text to Number in Excel (6 Easy Ways)<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 2- Using Flash Fill <\/strong><\/h3>\n<p style=\"text-align: justify;\">Here I will show you <strong>how to convert text to date format in Excel<\/strong> using Flash Fill. This option helps to recognize date patterns more efficiently, but it is less effective than the previous method.<\/p>\n<p style=\"text-align: justify;\">Follow the instructions below to use this option:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Enter the accurate date format manually in the next column.<\/li>\n<li>Then, press <strong>Ctrl + E<\/strong>.<\/li>\n<li>Flash Fill completes the pattern.<\/li>\n<\/ul>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 3- Change Text Strings to Date Using DATEVALUE<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>DATEVALUE<\/strong> function in MS Excel helps to convert a text string into a serial number that the Excel software recognizes as a date. But remember that this method is advanced and can be used when you want formula-based control.<\/p>\n<p style=\"text-align: justify;\">Formula to Use:<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong>=DATEVALUE(A1)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">After applying the above formula, change a cell format to <strong>Short Date<\/strong>. The value becomes a real date.<\/p>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 4-<\/strong> <strong>Apply the Custom Date Formats<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another workable method you can try is to apply the custom date format. This technique ensures your dates look appropriate and correct.<\/p>\n<p style=\"text-align: justify;\">Here is <strong>how to convert text to date in Excel<\/strong> by applying the custom formats:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Open the Excel workbook.<\/li>\n<li>Then, right-click a cell to select <strong>Format Cells<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6797 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/2.png\" alt=\"Format Cells Excel\" width=\"604\" height=\"467\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/2.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/2-300x232.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose <strong>Date<\/strong> or <strong>Custom<\/strong>.<\/li>\n<li>Now, apply a format such as <strong>dd-mm-yyyy <\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Your date remains the same but displays in a preferred style.<\/p>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 5-<\/strong> <strong>Use VALUE Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">Like DATEVALUE, there is another underrated function that can be used is the <strong>VALUE<\/strong>. This formula also helps to converts a word into a numeric value.<\/p>\n<p style=\"text-align: justify;\">Formula to Use:<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>=VALUE(A2)<\/strong><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9314 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/VALUE-function-to-change-text-to-date.png\" alt=\"How to Convert Text to Date in Excel\" width=\"431\" height=\"206\" \/><\/p>\n<p style=\"text-align: justify;\">The result turns into a valid Excel date and time. You can then format it as needed. Moreover, this function is useful for imported data.<\/p>\n<p><a name=\"s6\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 6-<\/strong> <strong>How to Convert Text to Date in Excel<\/strong> <strong>by<\/strong> <strong>Using Power Query<\/strong><\/h3>\n<p style=\"text-align: justify;\">In MS Excel, Power Query is\u00a0a powerful tool for connecting to, shaping, and converting data from numerous sources into a usable format. Besides, it saves time &amp; enables better analysis via features such as removing errors, merging tables, and changing types without complex coding.<\/p>\n<p style=\"text-align: justify;\">So, let\u2019s try this feature.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Select your data &gt;&gt; click on the <strong>Data<\/strong>.<\/li>\n<li>Choose <strong>From Table\/Range<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7292 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Transpose-Data-in-Excel-from-table.png\" alt=\"Data\" width=\"355\" height=\"126\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Under the Power Query, you have to choose the column.<\/li>\n<li>Now, click <strong>Data Type<\/strong> &gt;&gt; <strong>Date<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1503 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table1.png.pagespeed.ic_.dMB8vH-zDt.png\" alt=\"\" width=\"239\" height=\"303\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table1.png.pagespeed.ic_.dMB8vH-zDt.png 239w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table1.png.pagespeed.ic_.dMB8vH-zDt-237x300.png 237w\" sizes=\"auto, (max-width: 239px) 100vw, 239px\" \/><\/p>\n<p style=\"text-align: justify;\">After completion of these steps, the value becomes a real date.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-excel-to-word-without-losing-formatting\">How to Convert Excel to Word Without Losing Formatting?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Unique FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Change Date Format in Excel from Text to DD MM YYYY?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo change date format in Excel from text to DD MM YYYY, follow the steps below: <ul><li>Select the cell(s) you want to format. <\/li><li>Then, press <strong>CTRL+1<\/strong>. <\/li><li>Under a Format Cells box, click on <strong>Number<\/strong> tab. <\/li><li>Go to Category list, choose <strong>Date<\/strong>. <\/li><li>In Type, pick a date format (DD MM YYYY).                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Shortcut Key to Change a Number to a Date?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe shortcut to format a cell as a date, simply press CTRL + SHIFT + 3 from the opened spreadsheet. But if you want to format it as time, then press CTRL + SHIFT + 2.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Convert Text to Date in Power Query?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo convert text string to date in Power Query, follow these steps: <ul><li>Select the column(s) that hold the text data. <\/li><li>Click on the \u2018<strong>Transform<\/strong>\u2019 tab &gt;&gt; \u2018<strong>Data Type<\/strong>\u2019 option. <\/li><li>Choose \u2018Date\u2019 from a dropdown list of data types.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Change Date Format in Excel from Text to DD MM YYYY?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To change date format in Excel from text to DD MM YYYY, follow the steps below: &lt;ul&gt;&lt;li&gt;Select the cell(s) you want to format. &lt;\/li&gt;&lt;li&gt;Then, press <strong>CTRL+1<\/strong>. &lt;\/li&gt;&lt;li&gt;Under a Format Cells box, click on <strong>Number<\/strong> tab. &lt;\/li&gt;&lt;li&gt;Go to Category list, choose <strong>Date<\/strong>. &lt;\/li&gt;&lt;li&gt;In Type, pick a date format (DD MM YYYY).\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Shortcut Key to Change a Number to a Date?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The shortcut to format a cell as a date, simply press CTRL + SHIFT + 3 from the opened spreadsheet. But if you want to format it as time, then press CTRL + SHIFT + 2.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Convert Text to Date in Power Query?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To convert text string to date in Power Query, follow these steps: &lt;ul&gt;&lt;li&gt;Select the column(s) that hold the text data. &lt;\/li&gt;&lt;li&gt;Click on the \u2018<strong>Transform<\/strong>\u2019 tab &gt;&gt; \u2018<strong>Data Type<\/strong>\u2019 option. &lt;\/li&gt;&lt;li&gt;Choose \u2018Date\u2019 from a dropdown list of data types.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Wrapping Up<\/strong><\/h2>\n<p style=\"text-align: justify;\">Well, this is all about\u00a0<strong>how to convert text to date in Excel sheet <\/strong>in easy methods. Though I tried my best to put together the possible ways that will help you out. Simply follow the given steps one by one and change words to YYYYMMDD in MS Excel effortlessly.<\/p>\n<p style=\"text-align: justify;\">Thanks for reading this post!<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/convert-dates-stored-as-text-to-dates-8df7663e-98e6-4295-96e4-32a67ec0a680\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/convert-dates-stored-as-text-to-dates-8df7663e-98e6-4295-96e4-32a67ec0a680<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5205481\/how-to-convert-text-(28-02-2023)-to-date-in-excel\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5205481\/how-to-convert-text-(28-02-2023)-to-date-in-excel<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Want to know how to convert text to date in Excel sheet? If so, do not fret, you are reading &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Convert Text to Date in Excel? [6 Easy Ways]\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#more-9308\" aria-label=\"Read more about How to Convert Text to Date in Excel? [6 Easy Ways]\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":9310,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2014,2013],"class_list":["post-9308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-repair-excel","tag-how-to-convert-text-to-date-format-in-excel","tag-how-to-convert-text-to-date-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Convert Text to Date in Excel? [6 Easy Ways]<\/title>\n<meta name=\"description\" content=\"How to convert text to date in Excel? Follow the step-by-step methods mentioned here and change the text strings to date in no time\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Convert Text to Date in Excel? [6 Easy Ways]\" \/>\n<meta property=\"og:description\" content=\"How to convert text to date in Excel? Follow the step-by-step methods mentioned here and change the text strings to date in no time\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-12T14:32:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-12T14:47:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Convert Text to Date in Excel? [6 Easy Ways]\",\"datePublished\":\"2025-12-12T14:32:32+00:00\",\"dateModified\":\"2025-12-12T14:47:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\"},\"wordCount\":1056,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png\",\"keywords\":[\"how to convert text to date format in Excel\",\"how to convert text to date in Excel\"],\"articleSection\":[\"Repair Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\",\"name\":\"How to Convert Text to Date in Excel? [6 Easy Ways]\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png\",\"datePublished\":\"2025-12-12T14:32:32+00:00\",\"dateModified\":\"2025-12-12T14:47:34+00:00\",\"description\":\"How to convert text to date in Excel? Follow the step-by-step methods mentioned here and change the text strings to date in no time\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png\",\"width\":550,\"height\":310},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Convert Text to Date in Excel? [6 Easy Ways]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Convert Text to Date in Excel? [6 Easy Ways]","description":"How to convert text to date in Excel? Follow the step-by-step methods mentioned here and change the text strings to date in no time\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Convert Text to Date in Excel? [6 Easy Ways]","og_description":"How to convert text to date in Excel? Follow the step-by-step methods mentioned here and change the text strings to date in no time\u2026","og_url":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2025-12-12T14:32:32+00:00","article_modified_time":"2025-12-12T14:47:34+00:00","og_image":[{"width":550,"height":310,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Convert Text to Date in Excel? [6 Easy Ways]","datePublished":"2025-12-12T14:32:32+00:00","dateModified":"2025-12-12T14:47:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel"},"wordCount":1056,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png","keywords":["how to convert text to date format in Excel","how to convert text to date in Excel"],"articleSection":["Repair Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel","name":"How to Convert Text to Date in Excel? [6 Easy Ways]","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png","datePublished":"2025-12-12T14:32:32+00:00","dateModified":"2025-12-12T14:47:34+00:00","description":"How to convert text to date in Excel? Follow the step-by-step methods mentioned here and change the text strings to date in no time\u2026","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/12\/Convert-Text-to-Date-in-Excel.png","width":550,"height":310},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-date-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Convert Text to Date in Excel? [6 Easy Ways]"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=9308"}],"version-history":[{"count":5,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9308\/revisions"}],"predecessor-version":[{"id":9315,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9308\/revisions\/9315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/9310"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=9308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=9308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=9308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}