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.

[@alishanirgun5756]

Thanks for sharing it saved a lot of time

[@Dr.NarendraBhople]

Thank You Sir

[@TheAnalystinU]

Thanks for your comment 🤩

[@AkmalNurFirdausNorHarshah]

working, thanks for sharing

[@AkmalNurFirdausNorHarshah]

working, thanks for sharing

[@msdian07_die_heart_fan23]

Sir mai offfe mai ek sheet par 2 din se kam kar raha tha 9955 entry thi aapne 2 se kar rahe kam ko 2 sec mai karva diya Thanks sir thanx subscribe bhi kar diya sir love you sir

[@josekeylolo1935]

did not work 4 me

[@moh897]

MM-dd-YYYY hh:mm:ss to dd-mm-yyyy?

[@AnthonyHiiinoob]

This did not help at all

[@MrHuntercom]

Re4t