{"id":4096,"date":"2023-11-02T05:47:08","date_gmt":"2023-11-02T05:47:08","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=4096"},"modified":"2023-11-02T12:41:07","modified_gmt":"2023-11-02T12:41:07","slug":"excel-not-recognizing-date-format","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format","title":{"rendered":"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks"},"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;\">Microsoft Excel is an exceptional tool used to manage or analyze data. But sometimes, it happens that <strong>Excel not recognizing date format DD\/MM\/YYYY<\/strong>. Many users have reported the same issue where Excel fails to identify dates and difficulties in their spreadsheets.<!--more--><\/p>\n<p style=\"text-align: justify;\">Well, in this blog, I will discuss the common reasons behind this problem and other significant info regarding Excel not recognizing dates along with effective ways to troubleshoot it.<\/p>\n<p style=\"text-align: justify;\"><div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix corrupted Excel files, 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<h3 style=\"text-align: left;\"><strong>Quick Tricks:<\/strong><\/h3>\n<ol>\n<li><strong><a href=\"#s1\">Use Text To Columns<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Dates As Text<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Convert Date Into Numbers<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Format The Dates<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Use The VALUE Function<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">Using DATEVALUE Function<\/a><\/strong><\/li>\n<li><strong><a href=\"#s7\">Find &amp; Replace<\/a><\/strong><\/li>\n<li><strong><a href=\"#s8\">Run Error Checking<\/a><\/strong><\/li>\n<\/ol>\n<h2 style=\"text-align: justify;\"><strong>When <\/strong><strong>Excel Not Recognizing Dates Properly?<\/strong><\/h2>\n<p>Excel may not identify the date format:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">When you copy or import data into Excel all your date formats go wrong.<\/li>\n<li style=\"text-align: left;\">Excel recognizes the wrong dates and all the days and months get switched.<\/li>\n<li style=\"text-align: left;\">While working with the Excel file which is exported through the report. You may find that changing the date value cell format into a date is returning the wrong data.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Why Excel Doesn&#8217;t Recognize Date?<\/strong><\/h2>\n<p style=\"text-align: justify;\">This problematic situation can happen anytime and with anyone so you need to be prepared to fix this issue smartly. But before addressing it, you should extract the root causes of the problem. So, let\u2019s take a look:<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\">When your source file or from where you are importing the data follows the <strong>mm\/dd\/yy <\/strong>instead of the <strong>dd\/mm\/yy<\/strong> date format.<\/li>\n<li style=\"text-align: left;\">Due to formatting inconsistencies in the spreadsheet.<\/li>\n<li style=\"text-align: left;\">When trying to sort the dates column, all the data gets arranged in the incorrect order which leads to this issue.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>How to Fix Excel Not Recognizing Date Format?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Resolving the date not changing in Excel issue is not a tough task but for that, you need to know the right solution. Here are the fixes that you need to apply to fix this problem<strong>.<\/strong><\/p>\n<p><a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 1- Use Text To Columns<\/strong><\/h3>\n<p style=\"text-align: justify;\">Here are the fixes that you need to perform.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Firstly you need to highlight the cells having the dates. If you want then you select the complete column.<\/li>\n<li style=\"text-align: left;\">Now from the Excel ribbon, tap to the <strong>Data<\/strong> menu and choose the <strong>&#8216;Text to columns&#8217;<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4108 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-1.png\" alt=\"Excel not recognizing date format\" width=\"365\" height=\"349\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-1.png 365w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-1-300x287.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>In the opened dialog box choose the option of <strong>&#8216;Fixed width&#8217;<\/strong> and then hit the <strong>Next <\/strong>button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4115 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/text-to-column.png\" alt=\"text to column\" width=\"524\" height=\"400\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/text-to-column.png 524w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/text-to-column-300x229.png 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">If there are vertical lines with arrows present which are called <strong>column break lines<\/strong>. Then immediately go through the data section and make a double click on these for removing all of these. After that hit the <strong>Next <\/strong>button.<\/li>\n<li style=\"text-align: left;\">Now in the <strong>&#8216;Column data format&#8217;<\/strong> sections hit the date dropdown and choose the MDY or whatever date format you want to apply.<\/li>\n<li style=\"text-align: left;\">Hit the <strong>Finish<\/strong> button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4116 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/text-to-column-1.jpg\" alt=\"text to column 1\" width=\"512\" height=\"415\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/text-to-column-1.jpg 512w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/text-to-column-1-300x243.jpg 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<p style=\"text-align: justify;\">Very soon, your Excel will read out all the imported MDY dates and then convert it to the DMY format. All your problems with excel not recognizing date format dd\/mm\/yyyy\u00a0have now been fixed in just a few seconds.<\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-flash-fill-not-recognizing-pattern\">Fix Excel Flash Fill Not Recognizing Pattern (5 Quick Ways)<\/a><\/strong><\/p><\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 2- Dates As Text<\/strong><\/h3>\n<p style=\"text-align: justify;\">In the shown figure, you can see there is an imported dates column in which both data and time are showing. If in case you don\u2019t want to show the time and for this, you have set the format of the column as Short Date. But nothing happened <strong>date format not changing in Excel.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4107 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Dates-As-Text.png\" alt=\"Excel not recognizing date format\" width=\"402\" height=\"300\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Dates-As-Text.png 402w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Dates-As-Text-300x224.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Now the question arises <strong>why Excel date format is not changing?<\/strong><\/p>\n<p style=\"text-align: justify;\">\u00a0Mainly this happens because Excel is considering these dates as text. However, Excel won\u2019t apply number formatting in the text.<\/p>\n<p style=\"text-align: justify;\">Having doubt whether your date cell content is also counted as text then check out these signs to clear your doubt.<\/p>\n<ul style=\"text-align: justify;\">\n<li>If it is counted as text then Dates will appear left-aligned.<\/li>\n<li>You will see an apostrophe in the very beginning of the date.<\/li>\n<li>When you select more than one dates the <strong>Quick Calc<\/strong> which present in the <strong>Status Bar <\/strong>will only show you the Count, not the Numerical sum or Count.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4106 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Dates-As-Text-1.png\" alt=\"Dates As Text 1\" width=\"348\" height=\"302\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Dates-As-Text-1.png 348w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Dates-As-Text-1-300x260.png 300w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><br \/>\n<a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 3- Convert Date Into Numbers<\/strong><\/h3>\n<p style=\"text-align: justify;\">Once you identify that your date is a text format, it\u2019s time to change the date into numbers to resolve the issue. That\u2019s how Excel will store only the valid dates.<\/p>\n<p style=\"text-align: justify;\">For such a task, the best solution is to use the Text to Columns feature of Excel. Here is how it is to be used.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose the cells first in which your dates are present.<\/li>\n<li>From the Excel Ribbon, tap the <strong>Data.<\/strong><\/li>\n<li>Hit the <strong>Text to Columns option.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4108 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-1.png\" alt=\"excel text to column 1\" width=\"365\" height=\"349\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-1.png 365w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-1-300x287.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>In the first step, you need to choose the<strong> Delimited <\/strong>option, and click the <strong>Next.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4109 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-2.png\" alt=\"excel text to column 2\" width=\"401\" height=\"327\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-2.png 401w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-2-300x245.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>In the second step, from the <strong>delimiter <\/strong>section chooses <strong>Space <\/strong> In the below-shown preview pane you can see the dates divided into columns.<\/li>\n<li>Click the<strong> Next.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4110 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-3.png\" alt=\"Excel not recognizing date format\" width=\"402\" height=\"372\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-3.png 402w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-3-300x278.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">In the third step set the data type of each column:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Now in the <strong>preview pane,<\/strong> hit the date column and choose the Date option.<\/li>\n<li>From the Date drop-down, you have to select the date format in which your dates will be displayed.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4111 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-4.png\" alt=\"excel text to column 4\" width=\"402\" height=\"423\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-4.png 402w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-4-285x300.png 285w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Suppose, the dates are appearing in month\/day\/year format then choose the MDY.<\/p>\n<ul style=\"text-align: justify;\">\n<li>After that for each remaining column, you have to choose the option <strong>\u201cDo not import column (skip)\u201d<\/strong>.<\/li>\n<li>Tap the <strong>Finish<\/strong> option for converting the text format dates into real dates.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4112 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-5.png\" alt=\"excel text to column 5\" width=\"393\" height=\"375\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-5.png 393w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-text-to-column-5-300x286.png 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><br \/>\n<a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 4- Format The Dates to Fix Excel Not Recognizing Date Format<\/strong><\/h3>\n<p style=\"text-align: justify;\">After the conversion of the text dates or real dates, it\u2019s time to format them using the <strong>Number Format commands.<\/strong><\/p>\n<p style=\"text-align: justify;\">Here are a few signs that help you to recognize the real dates easily:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">If it is counted as text then Dates will appear right-aligned.<\/li>\n<li style=\"text-align: left;\">You will see no apostrophe at the very beginning of the date.<\/li>\n<li style=\"text-align: left;\">When you select more than one date the <strong>Quick Calc<\/strong> which is present in the <strong>Status Bar <\/strong>will only show you the Count, Numerical count, and the sum.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4113 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Format-the-Dates-1.png\" alt=\"Format the Dates 1\" width=\"402\" height=\"345\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Format-the-Dates-1.png 402w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Format-the-Dates-1-300x257.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">For the formatting of the dates, from the Excel ribbon choose the Number formats.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4114 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Format-the-Dates-2.png\" alt=\"Format the Dates 2\" width=\"378\" height=\"310\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Format-the-Dates-2.png 378w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Format-the-Dates-2-300x246.png 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/p>\n<p style=\"text-align: justify;\">Everything will work smoothly now, after converting text to real dates.<\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/resolve-excel-autorecover-not-working-issue\">Excel AutoRecover Not Working? Here\u2019s How to Fix It!<\/a><\/strong><\/p><\/blockquote>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 5- <\/strong><strong>Use The VALUE Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">The <strong>VALUE<\/strong> function is mainly used for compatibility with other workbook programs. Through this, you can easily convert the text string which looks like a number into a real number. Overall it\u2019s helpful for fixing any type of number not only the dates.<\/p>\n<p style=\"text-align: justify;\">Here is the Syntax which you need to use:<\/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 style=\"text-align: justify;\"><em><strong>=VALUE (text)\u00a0<\/strong><\/em><\/p>\n<\/div><\/div>\n<p style=\"text-align: justify;\">Where \u2018text\u2019 is referencing the cell having the date text string.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4104 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-VALUE-Function.png\" alt=\"Use The VALUE Function\" width=\"568\" height=\"169\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-VALUE-Function.png 568w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-VALUE-Function-300x89.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Notes:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\">If the text string which you are using is not in the format that is well recognized by Excel then it will surely give you the #VALUE! Error.<\/li>\n<li style=\"text-align: left;\">For your date, Excel will return the serial numbers, so you need to set the cell format as the date for making the serial number appear just like a date.<\/li>\n<\/ol>\n<p><a name=\"s6\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 6- Using <\/strong><strong>DATEVALUE Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">DATEVALUE is very much similar to the VALUE function. The only difference is that it can convert the text string which appears like a date into the date serial number.<\/p>\n<p style=\"text-align: justify;\">With the VALUE function, you can also convert a cell having the date and time which is formatted as text. Whereas, the DATEVALUE function, ignores the time section of the text string.<\/p>\n<p style=\"text-align: justify;\">Here is the Syntax which you need to use:<\/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 style=\"text-align: justify;\"><em><strong>=DATEVALUE(date_text)<\/strong><\/em><\/p>\n<\/div><\/div>\n<p style=\"text-align: justify;\">Where \u2018date_text\u2019 is referencing the cell having the date text string.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4099 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/DATEVALUE-Function.png\" alt=\"Using DATEVALUE Function\" width=\"573\" height=\"170\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/DATEVALUE-Function.png 573w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/DATEVALUE-Function-300x89.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><br \/>\n<a name=\"s7\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 7- How to Solve Excel Not Recognizing Dates Using <\/strong><strong>Find &amp; Replace?<\/strong><\/h3>\n<p style=\"text-align: justify;\">In your dates, if the decimal is used as delimiters like this, 1.01.2014 then the DATEVALUE and VALUE are of no use<\/p>\n<p style=\"text-align: justify;\">In such cases using Excel <strong>Find &amp; Replace<\/strong> is the best option. Using the Find and Replace you can easily replace decimal with the forward slash. This will convert the text string into an Excel serial number.<\/p>\n<p style=\"text-align: justify;\"><strong>Here are the steps to use find &amp; replace:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Choose the file in which you are getting the issue<strong>.<\/strong><\/li>\n<li>From your keyboard press<strong> CTRL+H <\/strong> This will open the find and replace dialog box on your screen.<\/li>\n<li>Now in the <strong>\u2018Find what\u2019 <\/strong>field put a decimal, and in <strong>the \u2018replace\u2019<\/strong> field put a forward slash.<\/li>\n<li>Tap the <strong>\u2018Replace All\u2019 <\/strong>option.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4103 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-find-and-replace.png\" alt=\"Using Find &amp; Replace\" width=\"457\" height=\"200\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-find-and-replace.png 457w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-find-and-replace-300x131.png 300w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/p>\n<p style=\"text-align: justify;\">Excel can now easily identify that your text is in number and thus automatically format it like a date.<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">HELPFUL ARTICLE<\/span>: <a class=\"row-title steem-keychain-checked\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-find-and-replace-not-working\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"\u201c6 Ways To Fix Excel Find And Replace Not Working Issue\u201d (Edit)\">Fix Excel Find And Replace Not Working Issue<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s8\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 8- Run <\/strong><strong>Error Checking<\/strong><\/h3>\n<p style=\"text-align: justify;\">Last but not least option that is left to<strong> fix Excel not recognizing dates <\/strong>is using the inbuilt error-checking option of Excel. This inbuilt tool always looks for the numbers formatted as text.<\/p>\n<p style=\"text-align: justify;\">You can easily identify if there is an error, as it puts a small green triangle sign in the top left corner of the cell. When you select this cell you will see an exclamation mark across it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4100 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-1.png\" alt=\"excel error checking 1\" width=\"182\" height=\"136\" \/><\/p>\n<p style=\"text-align: justify;\">By hitting this exclamation mark you will get some more options related to your text:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4101 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-2.png\" alt=\"excel error checking 2\" width=\"366\" height=\"241\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-2.png 366w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-2-300x198.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/p>\n<p style=\"text-align: justify;\">In the above-shown example, the year in the date is only showing 2 digits. Thus Excel is asking in what format I need to convert the 19XX or 20XX.<\/p>\n<p style=\"text-align: justify;\">You can easily fix all the listed dates with this error-checking option. For this, you need to choose all your cells having date text strings right before hitting the Exclamation mark on your first selected cell.<\/p>\n<p style=\"text-align: justify;\"><strong>Steps to turn on error checking option:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Hit the office icon present in the top left corner of the opened Excel workbook. Now go to the <strong>Excel Options &gt; Formulas<\/strong><\/li>\n<li style=\"text-align: left;\">From the error checking section choose \u201c<strong>enable background error checking\u201d option.<\/strong><\/li>\n<li style=\"text-align: left;\">Now from the error checking rules choose the <strong>\u201ccells containing years represented as 2 digits\u201d<\/strong> and <strong>\u201cnumber formatted as text or preceded by an apostrophe\u201d.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4102 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-3.png\" alt=\"excel error checking 3\" width=\"594\" height=\"479\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-3.png 594w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel-error-checking-3-300x242.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/p>\n<h2 style=\"text-align: left;\"><strong>Use Excel Repair Software to Solve Errors &amp; Issues in Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">If you face any error or issue in Excel due to file corruption, then you can go for the first-rated <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\"><strong>Excel Repair Tool<\/strong><\/a>. This program is capable of <a href=\"https:\/\/www.repairmsexcel.com\/blog\/13-ways-to-repair-corrupt-excel-file\" target=\"_blank\" rel=\"noopener\"><strong>fixing severely corrupted Excel files<\/strong><\/a> and restoring all the tables, charts, images, cell comments, formulas, filters, and sorts from that Excel workbook.<\/p>\n<p style=\"text-align: justify;\">Apart from that, you can download the free demo version of this tool to scan &amp; preview recoverable data from a file.<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Can I Set a Default Date Format for All Workbooks in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, you can easily set the default date format for all workbooks in MS Excel by navigating to \u2018File\u2019 menu &gt;&gt; \u2018Options\u2019 &gt;&gt; choose \u2018Advanced\u2019. In the \u2018General\u2019 tab, you can set your chosen date format as the default.                    <\/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>Why Does Excel Sometimes Convert Dates to A Different Format Automatically?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tExcel might convert dates to a different format automatically if it detects data inconsistencies or if the regional settings don\u2019t match the date format used.                    <\/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 Should I Do If Excel Changes the Date Format Automatically When I Enter Dates?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf your Excel changes the date format automatically when you enter dates, it might be because of incorrect regional settings. To tackle the situation, you have to go to the File tab &gt;&gt; Options &gt;&gt; Advanced option. In the Editing Options, simply uncheck the option \u2018Automatically insert a decimal point\u2019.                    <\/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>Are There Any Shortcuts to Change Date Formats In Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, there is shortcuts to change date formats in MS Excel. Simply, press on \u2018<strong>Ctrl+1\u2019<\/strong> keys together to open a Format Cells dialogbox, then go to \u2018Number\u2019 tab &gt;&gt; select \u2018Date\u2019. Select the wanted format from that list.                    <\/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>Can I Convert Text Dates to Proper Excel Date Values?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, you can use <strong>DATEVALUE<\/strong> function to convert text dates to proper Excel date values.                     <\/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 Can I Prevent Date Format Issues When Importing Data into Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo prevent date format problems when importing data into Excel spreadsheet, ensure to format the dates constantly in the source data.                    <\/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\": \"Can I Set a Default Date Format for All Workbooks in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, you can easily set the default date format for all workbooks in MS Excel by navigating to \u2018File\u2019 menu &gt;&gt; \u2018Options\u2019 &gt;&gt; choose \u2018Advanced\u2019. In the \u2018General\u2019 tab, you can set your chosen date format as the default.\"\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\": \"Why Does Excel Sometimes Convert Dates to A Different Format Automatically?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Excel might convert dates to a different format automatically if it detects data inconsistencies or if the regional settings don\u2019t match the date format used.\"\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 Should I Do If Excel Changes the Date Format Automatically When I Enter Dates?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If your Excel changes the date format automatically when you enter dates, it might be because of incorrect regional settings. To tackle the situation, you have to go to the File tab &gt;&gt; Options &gt;&gt; Advanced option. In the Editing Options, simply uncheck the option \u2018Automatically insert a decimal point\u2019.\"\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\": \"Are There Any Shortcuts to Change Date Formats In Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, there is shortcuts to change date formats in MS Excel. Simply, press on \u2018<strong>Ctrl+1\u2019<\/strong> keys together to open a Format Cells dialogbox, then go to \u2018Number\u2019 tab &gt;&gt; select \u2018Date\u2019. Select the wanted format from that list.\"\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\": \"Can I Convert Text Dates to Proper Excel Date Values?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, you can use <strong>DATEVALUE<\/strong> function to convert text dates to proper Excel date values.\"\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 Can I Prevent Date Format Issues When Importing Data into Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To prevent date format problems when importing data into Excel spreadsheet, ensure to format the dates constantly in the source data.\"\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>Final Thoughts<\/strong><\/h2>\n<p style=\"text-align: justify;\">That\u2019s it! I hope the outlined workarounds have helped you resolve <strong>Excel not recognizing the date format<\/strong> issue. All you need to do is to try them accordingly to deal with the situation.<\/p>\n<p style=\"text-align: justify;\">If you\u2019ve any questions related to this topic, feel free to ask us on <a href=\"https:\/\/www.facebook.com\/MS-Excel-Repair-Tool-1569953153234271\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Facebook<\/strong><\/a>\u00a0and\u00a0<a href=\"https:\/\/twitter.com\/repairmsexcel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Twitter<\/strong><\/a>.<\/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:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/excel-not-recognizing-dates-properly\/2c8c61e6-28e3-480d-a37d-d144414ce1ad\" target=\"_blank\" rel=\"noopener\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/excel-not-recognizing-dates-properly\/2c8c61e6-28e3-480d-a37d-d144414ce1ad<\/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>Microsoft Excel is an exceptional tool used to manage or analyze data. But sometimes, it happens that Excel not recognizing &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#more-4096\" aria-label=\"Read more about Resolve Excel Not Recognizing Date Format- Time-Saving Tricks\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":7356,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1536,1534,1535],"class_list":["post-4096","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-repair-excel","tag-excel-doesnt-recognize-date","tag-excel-not-recognizing-date-format-dd-mm-yyyy","tag-excel-not-recognizing-dates","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Resolve Excel Not Recognizing Date Format- Time-Saving Tricks<\/title>\n<meta name=\"description\" content=\"Whether you&#039;re a beginner or an Excel pro, the solutions mentioned here will help you to fix Excel not recognizing date format issue smartly.\" \/>\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\/excel-not-recognizing-date-format\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks\" \/>\n<meta property=\"og:description\" content=\"Whether you&#039;re a beginner or an Excel pro, the solutions mentioned here will help you to fix Excel not recognizing date format issue smartly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-02T05:47:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T12:41:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"328\" \/>\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=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks\",\"datePublished\":\"2023-11-02T05:47:08+00:00\",\"dateModified\":\"2023-11-02T12:41:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format\"},\"wordCount\":2122,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png\",\"keywords\":[\"excel doesn't recognize date\",\"Excel not recognizing date format dd\/mm\/yyyy\",\"excel not recognizing dates\"],\"articleSection\":[\"Repair Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format\",\"name\":\"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png\",\"datePublished\":\"2023-11-02T05:47:08+00:00\",\"dateModified\":\"2023-11-02T12:41:07+00:00\",\"description\":\"Whether you're a beginner or an Excel pro, the solutions mentioned here will help you to fix Excel not recognizing date format issue smartly.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png\",\"width\":550,\"height\":328,\"caption\":\"Excel Not Recognizing Date Format\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks\"}]},{\"@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":"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks","description":"Whether you're a beginner or an Excel pro, the solutions mentioned here will help you to fix Excel not recognizing date format issue smartly.","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\/excel-not-recognizing-date-format","og_locale":"en_US","og_type":"article","og_title":"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks","og_description":"Whether you're a beginner or an Excel pro, the solutions mentioned here will help you to fix Excel not recognizing date format issue smartly.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format","og_site_name":"Excel File Repair Blog","article_published_time":"2023-11-02T05:47:08+00:00","article_modified_time":"2023-11-02T12:41:07+00:00","og_image":[{"width":550,"height":328,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks","datePublished":"2023-11-02T05:47:08+00:00","dateModified":"2023-11-02T12:41:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format"},"wordCount":2122,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png","keywords":["excel doesn't recognize date","Excel not recognizing date format dd\/mm\/yyyy","excel not recognizing dates"],"articleSection":["Repair Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format","url":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format","name":"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png","datePublished":"2023-11-02T05:47:08+00:00","dateModified":"2023-11-02T12:41:07+00:00","description":"Whether you're a beginner or an Excel pro, the solutions mentioned here will help you to fix Excel not recognizing date format issue smartly.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/excel252520not252520recognizing252520date252520format.png","width":550,"height":328,"caption":"Excel Not Recognizing Date Format"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-not-recognizing-date-format#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Resolve Excel Not Recognizing Date Format- Time-Saving Tricks"}]},{"@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\/4096","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=4096"}],"version-history":[{"count":4,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/4096\/revisions"}],"predecessor-version":[{"id":7358,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/4096\/revisions\/7358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/7356"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=4096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=4096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=4096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}