{"id":40532,"date":"2024-03-24T16:44:41","date_gmt":"2024-03-24T15:44:41","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=40532"},"modified":"2024-05-26T21:24:19","modified_gmt":"2024-05-26T19:24:19","slug":"convert-dates-to-mm-yy","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-dates-to-mm-yy\/","title":{"rendered":"Convert Dates to MM YY Format in Excel: Quick Formatting Tips"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-40730 size-large\" title=\"Convert dates to mm yy\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy-1024x576.png\" alt=\"Convert dates to mm yy\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/Convert-dates-to-mm-yy.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a>&#8216;s ability to manage date formats offers a bridge between simplicity and complexity, catering to both basic and advanced user needs. By understanding Excel&#8217;s default date settings and mastering custom dates to mm yy format, users can ensure their data is clear, consistent, and aesthetically pleasing, enhancing both functionality and collaboration.<\/p>\n<h3>Key Takeaways<\/h3>\n<ul>\n<li>Excel pulls default date formats from the system&#8217;s regional settings, which can be seen and changed in the Format Cells dialog box.<\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/custom-date-formats-in-excel\/\" target=\"_blank\" rel=\"noopener\">Custom date formats<\/a> are essential for clarity, uniformity, and adherence to specific reporting standards, making data analysis and presentation more effective.<\/li>\n<li>Built-in date format options provide a quick way to change date presentations, with a vast array of styles available from the Home tab.<\/li>\n<li>Crafting custom formats, like MM YY, allows for focused data presentation, ideal for summaries and tracking over time without altering the underlying data.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-dates-to-mm-yy\/#Introducing_Excel_Date_Formats\" title=\"Introducing Excel Date Formats\">Introducing Excel Date Formats<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-dates-to-mm-yy\/#Detailed_Guide_to_Converting_Dates\" title=\"Detailed Guide to Converting Dates\">Detailed Guide to Converting Dates<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-dates-to-mm-yy\/#Advanced_Techniques_for_Date_Conversion\" title=\"Advanced Techniques for Date Conversion\">Advanced Techniques for Date Conversion<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-dates-to-mm-yy\/#Optimizing_Your_Workflow_Tips_and_Tricks\" title=\"Optimizing Your Workflow: Tips and Tricks\">Optimizing Your Workflow: Tips and Tricks<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-dates-to-mm-yy\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introducing_Excel_Date_Formats\"><\/span>Introducing Excel Date Formats<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Understanding Excel&#8217;s Default Date Settings<\/h3>\n<p>In Excel, dates can take several shapes and forms, depending on how users wish to display them. Understanding the default date settings is crucial before tailoring them to specific needs. Essentially, Excel pulls these default formats, short and long, from your system&#8217;s regional settings.<\/p>\n<p>Have you noticed how when you input dates, they automatically take on a certain look? Those are the default settings at play. To see what format you&#8217;re currently working with, just cast a glance at the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-1-format-cells\/\" target=\"_blank\" rel=\"noopener\">Format Cells <\/a>dialog box, where the default selections have asterisks next to them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A223A31.369978_Date_Format_MM_YY_in_Excel_1.png\" alt=\"Dates to MM YY\" width=\"990\" height=\"927\" \/><\/p>\n<h3>The Importance of Custom Date Formats<\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-custom-dates-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Custom date formats in Excel<\/a> are more than a matter of visual preference; they&#8217;re a tool for ensuring clarity and uniformity within your data. Imagine trying to collaborate when one user&#8217;s data screams &#8216;mm\/dd\/yyyy&#8217; while someone else insists on &#8216;dd-mm-yy&#8217;. This can lead to confusion and errors, particularly when it comes to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> and reporting where the correct interpretation of dates is critical.<\/p>\n<p>Moreover, custom date formats help maintain consistency across documents, which is essential for businesses and organizations that need to abide by specific reporting standards or formats. They also cater to the aesthetic aspect of data presentation, ensuring that reports look polished, and professional, and are formatted according to company policy or customer expectations. It&#8217;s about more than just making numbers pretty; it&#8217;s a vital functional element that can streamline workflows and prevent miscommunication.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Detailed_Guide_to_Converting_Dates\"><\/span>Detailed Guide to Converting Dates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Using Built-in Date Format Options<\/h3>\n<p>When you want to quickly change the presentation of dates in Excel, the built-in date format options are your first line of assistance. To take advantage of these, just select the dates you want to reformat, navigate to the Home tab on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-f1-hide-unhide-the-ribbon\/\" target=\"_blank\" rel=\"noopener\">the ribbon<\/a>, and find the Number group. Clicking the little arrow next to the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/predetermined-number-formatting\/\" target=\"_blank\" rel=\"noopener\">Number Format<\/a> box unveils a dropdown menu with various formats\u2014the ubiquitous short date, its more informative cousin the long date, and, of course, time.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A473A59.928689_Date_Format_MM_YY_in_Excel_2.png\" alt=\"Dates to MM YY\" width=\"1413\" height=\"457\" \/><\/p>\n<p>One more click is all it takes to shift your date&#8217;s attire from casual to formal or any style in-between that Excel offers. It&#8217;s almost like magic! If you have a go-to format that you use often, this is the quickest way to apply consistent styling across your data sets without much fuss.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A483A09.913844_Date_Format_MM_YY_in_Excel_4.png\" alt=\"Dates to MM YY\" width=\"1421\" height=\"770\" \/><\/p>\n<p>The new formatting will be applied in the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A483A17.891678_Date_Format_MM_YY_in_Excel_3.png\" alt=\"Dates to MM YY\" width=\"995\" height=\"423\" \/><\/p>\n<p>In the event none of the present options fits the bill, you aren&#8217;t out of choices. The More Number Formats link at the bottom of the dropdown list leads you to a broader collection of styles.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A483A29.431905_Date_Format_MM_YY_in_Excel_.png\" alt=\"Dates to MM YY\" width=\"1236\" height=\"767\" \/><\/p>\n<p>From there, tailor your dates precisely how you like them\u2014Excel is quite accommodating in that regard.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A483A42.968675_Date_Format_MM_YY_in_Excel_6.png\" alt=\"Dates to MM YY\" width=\"1093\" height=\"856\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Crafting Dates to MM YY format<\/h3>\n<p>When the existing options in Excel don&#8217;t suffice, crafting a custom date format becomes your creative playground. Let&#8217;s say you want your dates to sing a specific tune: just the month and year, in a MM YY format. Here&#8217;s how you can set up that stage to convert date to mm yy format:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Select the cells where you want this special date format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A513A07.550675_Date_Format_MM_YY_in_Excel_5.png\" alt=\"Dates to MM YY\" width=\"997\" height=\"495\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Then, move your cursor to the Home tab and click on the Number group&#8217;s little launcher, or simply press <code>Ctrl + 1<\/code>, to open the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-cells-special-numbers-excel\/\" target=\"_blank\" rel=\"noopener\">Format Cells<\/a> dialog.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A513A22.149130_Date_Format_MM_YY_in_Excel_7.png\" alt=\"Dates to MM YY\" width=\"676\" height=\"625\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> In the dialog that appears, choose &#8216;Custom&#8217; from the Category list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A513A33.133340_Date_Format_MM_YY_in_Excel_8.png\" alt=\"Dates to MM YY\" width=\"674\" height=\"626\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong> <\/span>Now, in the Type box, enter <code>mm yy<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A513A43.554373_Date_Format_MM_YY_in_Excel_9.png\" alt=\"Dates to MM YY\" width=\"676\" height=\"620\" \/><\/p>\n<p>The result looks like this &#8211;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Dates to MM YY\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A523A01.928720_Date_Format_MM_YY_in_Excel_10.png\" alt=\"Dates to MM YY\" width=\"993\" height=\"425\" \/><\/p>\n<p>This sequence crafts a simple attire for your dates, focusing on just the month and year, giving your data a neat, uniform look perfect for summarizing information over time. Whether for tracking events, milestones, or financial periods, this format keeps it succinct.<\/p>\n<p>Keep in mind that although this approach changes the display format, it doesn&#8217;t alter the underlying date. So, while your spreadsheet might now showcase a simplified <code>04 23<\/code>, rest assured the full date is still there, working behind the scenes.<\/p>\n<p>While Excel offers a wide range of date format symbols, remember that &#8216;mm&#8217; stands for the month and &#8216;yy&#8217; for the year. By combining these two, you maintain the integrity of your data while presenting it just the way you need.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Techniques_for_Date_Conversion\"><\/span>Advanced Techniques for Date Conversion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Leveraging Formulas for Conversion<\/h3>\n<p>Leveraging formulas in Excel provides a dynamic way to convert dates into your desired format, especially when dealing with a vast array of data. Formulas can be designed to extract specific parts of a date, such as the month and year, and piece them together in a new format.<\/p>\n<p>One such formula that you might find handy is the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-text-function\/\" target=\"_blank\" rel=\"noopener\"><code>TEXT<\/code> function<\/a>, which can transform dates into a plethora of textual representations. To achieve the MM YY format, you would use:<\/p>\n<p><code>=TEXT(your_date_cell,\"MM YY\")<\/code><\/p>\n<p>Replace <code>your_date_cell<\/code> with the actual cell containing the date you wish to convert.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"dates to mm yy\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A533A30.029240_Date_Format_MM_YY_in_Excel_12.png\" alt=\"dates to mm yy\" width=\"678\" height=\"327\" \/><\/p>\n<p>By applying this formula to a column next to your dates, you instantly create a new column with the converted format. This method ensures that your original dates remain intact while granting the versatility to display them however you like.<\/p>\n<p>&nbsp;<\/p>\n<h3>Utilizing Text Functions for a Quick Fix<\/h3>\n<p>Sometimes, you don&#8217;t need the full heft of a formula to convert your dates; a quick textual manipulation is all it takes. Utilizing text functions like <code>LEFT<\/code>, <code>MID<\/code>, and <code>RIGHT<\/code> alongside <code>DATE<\/code> and <code>TEXT<\/code> can be ideal for simple fixes, particularly if your data has been unceremoniously plopped down as text rather than in the proper date format Excel loves.<\/p>\n<p>For instance, should you have dates typed out as &#8216;ddmmyyyy&#8217; and need them in a &#8216;MM YY&#8217; format, you could combine <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-character-from-string\/\" target=\"_blank\" rel=\"noopener\"><code>RIGHT<\/code><\/a>, <code>MID<\/code>, and <code>TEXT<\/code> functions like this:<\/p>\n<p><code>=TEXT(DATE(RIGHT(A1,4), MID(A1,3,2), LEFT(A1,2)),\"MM YY\")<\/code><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"dates to mm yy\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia635642112024-03-19T193A553A47.489496_Date_Format_MM_YY_in_Excel_13.png\" alt=\"dates to mm yy\" width=\"944\" height=\"314\" \/><\/p>\n<p>Here, you&#8217;re pulling the year from the right, the month from the middle, and the day from the left of your text string, then weaving them into an actual date with <code>DATE<\/code> before applying the <code>TEXT<\/code> function to format it.<\/p>\n<p>Text functions provide a nimble, straightforward way to reshape your date data when it strays from the pure format. They&#8217;re quick to implement and can significantly simplify data prep in Excel..<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Optimizing_Your_Workflow_Tips_and_Tricks\"><\/span>Optimizing Your Workflow: Tips and Tricks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Shortcuts for Speedier Date Formatting<\/h3>\n<p>Navigating through menus to format dates in Excel can be a drag on your productivity. Luckily, the program offers some nifty <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/333-excel-keyboard-shortcuts\/\" target=\"_blank\" rel=\"noopener\">keyboard shortcuts<\/a> that can significantly speed up the process. Here&#8217;s one to commit to memory:<\/p>\n<p>Want to quickly set a date format to &#8216;dd-mmm-yy&#8217;? Just highlight the cell or range of cells containing the dates and press <code>Ctrl+Shift+#<\/code>. Instantly, your dates will adopt the &#8217;01-Jan-15&#8242; style format.<\/p>\n<p>Don&#8217;t forget, though, while this shortcut is quick and convenient, it does apply the format based on the default &#8216;short date&#8217; style, which might not match your regional settings. Therefore, if you&#8217;re looking for a different presentation, you&#8217;ll need to delve into the Format Cells dialog box for a more tailored touch.<\/p>\n<p>Leveraging shortcuts like this can make you an Excel wizard in no time, saving you moments with every press that can add up to hours saved in the long run. Just remember, the more you practice them, the more inherent they become\u2014muscle memory can be a powerful ally in the realm of data manipulation.<\/p>\n<p>&nbsp;<\/p>\n<h3>Best Practices for Data Consistency and Accuracy<\/h3>\n<p>For the meticulous minds and purveyors of pixel-perfect spreadsheets, nailing down data consistency and accuracy is the endgame. Here&#8217;s some expert advice to keep your date data on point and reliable:<\/p>\n<ol>\n<li data-list=\"ordered\"><strong>Use Single-Cell Input:<\/strong> Always input dates in individual cells. Merging day, month, and year into separate cells invites errors and makes calculations unnecessarily complex.<\/li>\n<li data-list=\"ordered\"><strong>Apply Uniform Formatting:<\/strong> Once you&#8217;ve chosen a date format, apply it uniformly across your workbook to maintain consistency. This is especially critical when multiple people access the document.<\/li>\n<li data-list=\"ordered\"><strong>Validation Rules:<\/strong> Implement data validation rules to ensure that only dates in the correct format can be inputted into cells, preventing the classic slip of &#8216;Feb 30th&#8217;.<\/li>\n<li data-list=\"ordered\"><strong>Avoid Manual Typing:<\/strong> Whenever possible, use Excel functions or dropdown calendars for date inputs to sidestep human error.<\/li>\n<li data-list=\"ordered\"><strong>Double-Check Imports:<\/strong> When importing or copying dates from other sources, always double-check them for format consistency and accuracy against your Excel sheet standards.<\/li>\n<\/ol>\n<p>Remember, consistent and accurate dates not only look better but also make your data more trustworthy and easier to analyze. It&#8217;s worth the effort to iron out the wrinkles for a sleek, error-free experience.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>How Can I Convert a Series of Dates all at Once?<\/h3>\n<p>To convert a series of dates all at once in Excel, you can apply the same formatting to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-select-multiple-cells\/\" target=\"_blank\" rel=\"noopener\">multiple cells<\/a> simultaneously. Select the range containing the dates, then use the &#8216;Format Cells&#8217; dialog to choose or create the desired date format.<\/p>\n<h3>Why Aren&#8217;t My Dates Converting Properly in Excel?<\/h3>\n<p>If your dates aren&#8217;t converting properly in Excel, it&#8217;s common that they may be <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-numbers-as-text\/\" target=\"_blank\" rel=\"noopener\">formatted as text<\/a> or affected by regional settings. Use the<a href=\"https:\/\/support.microsoft.com\/en-au\/office\/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252\" target=\"_blank\" rel=\"nofollow noopener\"> <code>DATEVALUE()<\/code> function<\/a> on these &#8216;text dates&#8217; to turn them into actual date values. Additionally, ensure your computer&#8217;s regional settings match the date format of your data.<\/p>\n<h3>How do I change the date format to MM YY in Excel?<\/h3>\n<p>To change the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-date-format\/\" target=\"_blank\" rel=\"noopener\">date format to MM YY<\/a> in Excel, select the dates you wish to change, right-click and choose &#8216;Format Cells,&#8217; then select &#8216;Custom&#8217; in the Category list. In the Type field, enter &#8220;MM YY&#8221; and click &#8216;OK&#8217; to apply the new format.<\/p>\n<h3>How do you convert date from MM DD YYYY to DD MM YYYY in Excel?<\/h3>\n<p>To <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-excel-time-to-decimal\/\" target=\"_blank\" rel=\"noopener\">convert the date from MM<\/a> DD YYYY to DD MM YYYY in Excel, use the <code>Format Cells<\/code> feature. Select your dates, right-click, choose &#8216;Format Cells&#8217;, click on &#8216;Custom&#8217; and type &#8220;DD MM YYYY&#8221; into the Type box, then click &#8216;OK&#8217;.<\/p>\n<h3>How I can change the dates to be 01\/04\/2023 13:00 instead of 04\/01\/2023?<\/h3>\n<p>To change dates from the format 04\/01\/2023 to 01\/04\/2023 13:00 in Excel, first ensure the dates are actual date values and not text. Then, select the cells, go to &#8216;Format Cells&#8217;, choose &#8216;Custom&#8217;, and type &#8220;DD\/MM\/YYYY HH:MM&#8221; in the Type field. Click &#8216;OK&#8217; to apply the change.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel like a pro! Get top tips for easy MM YY dates conversion, tackling common issues &amp; leveraging formulas for perfect formatting accuracy.<\/p>\n","protected":false},"author":1,"featured_media":40730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Convert Dates to MM YY Format in Excel: Quick Formatting Tips","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[13,3],"tags":[2015,2158,2159],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/40532"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=40532"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/40532\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/40730"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=40532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=40532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=40532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}