How to convert date / month / year format to month / day / year format in Excel


If your job requires using more than one language in Excel, then you will have problems converting European date format (day / month / year) to US date format ( month day Year). The following article Taimienphi.vn will guide you how to convert date / month / year format to month / day / year format in Excel.


Suppose you work in a bank, and you download documents or if someone sends you a spreadsheet in TXT, HTML or CVS format, the date in the spreadsheet will be delayed if you type in the language You are in an Excel spreadsheet, so you need to format the date in Excel correctly so you don’t get this error.

However, you can convert date / month / year format to month / day / year format in Excel as per the instructions below.

If you install the English version of Microsoft Excel 2013, when you open a file that is stored in European or Latin American date format, Excel will not recognize the date, so you cannot apply the format. day. And you cannot convert October 1, 2014 to November 10, 2014.

If someone sends you a document that has been saved in a spreadsheet format, you should have no problem switching from one language to another.

In the example below, the spreadsheet is downloaded in HTML format from a bank site in Spain. The date in the spreadsheet is applied with the format of day / month / year (dd / mm / yyyy).

Step 1: The way to convert date / month / year format to month / day / year format is to use text strings, such as October 1, 2014, and convert to January 10, 2014. Then insert the edited text string in date format into the Date () function in Excel.

How to convert textures to Excel values ​​in Excel format in Excel 2

Step 2: To edit date formats, you use the LEFT, MID, RIGHT, and DATE functions:

– LEFT function: This function to get characters from the left. In the example below the function = LEFT (B16,2) means to take the first 2 characters from the date in cell B16.

– MID function: MID function here is where the middle character begins. So = MID (B16,4,2) means starting at position 4 and then taking two characters there. Start at position 4 because the first 3 characters are the date and the slash (/).

RIGHT function: RIGHT function here is the opposite of LEFT. Here = RIGHT (B16,4) means there are 4 final characters. The following example will produce the final result.

How to convert textures to Excel values ​​in Excel format in Excel 3

Note that you can write all the formulas in one cell to avoid the use of writing each formula for each column, but this will make you confused and more difficult to read.

Step 3: Now the day / month / year format has been converted to the month / day / year format, and you can continue working on your Excel spreadsheet without any errors.

https://thuthuat.taimienphi.vn/cach-chuyen-doi-dinh-dang-ngay-thang-nam-thanh-dinh-dang-thang-ngay-nam-trong-excel-26181n.aspx
How are your comments on how to convert date / month / year format to month / day / year format in Excel? Please share your ideas for Taimienphi.vn offline. In Excel, there are many different date functions, if you are not familiar with those functions, refer to the article summarizing date function in Excel here.

.

Add a Comment

Your email address will not be published. Required fields are marked *