Change Date format DD-MM-YYYY to MM-DD-YYYY in excel

#shots To change the date format in Excel using text, you can use the TEXT function. The TEXT function converts a date to a text string in a specific format.

Here's how to use the TEXT function to change the date format:

In a cell, type "=TEXT(" followed by the cell reference of the date you want to format. For example, if your date is in cell A1, you would type "=TEXT(A1,".
Enter the desired date format in quotation marks. For example, if you want to display the date as "MM/DD/YYYY," you would type "MM/DD/YYYY")".
Close the parentheses and press Enter.
The cell will now display the date in the format you specified. You can copy and paste this formula to other cells to apply the same format to multiple dates.

Note: The result of the TEXT function is a text string, not a date value. If you need to perform calculations with the formatted date, you may need to convert it back to a date value using the DATEVALUE function.