HOW TO CONVERT TEXT TO DATE FORMAT,HOW TO CHANGE YOUR CALENTER DATE FORMAT.
Want to change the date format in Excel without using any formulas?
📅In this quick tutorial, we’ll show you how to update date formats easily using Excel’s built-in features. No coding or formula needed – perfect for beginners!
✅ Format date to DD-MM-YYYY, MM-DD-YYYY, or custom styles
✅ Works on Excel 2016, 2019, 2021 & Office 365
👉 Subscribe for more Excel tips in Tamil & English!
#Excellent #ExcelTutorial #DateFormatExcel #ExcelInTamil #ExcelShorts #KGuruTech777
✅ Steps to Change Date Format in Excel (No Formula Needed):
1. Select the Date Cells:
Highlight the cells that contain the dates you want to format.
2. Right-click → Click "Format Cells…"
3. In the Format Cells window:
Go to the "Number" tab
Select "Date" from the list on the left.
You'll see different date formats (e.g., 14/03/2012, March 14, 2012, etc.)
4. Choose your preferred format and click OK.
📌 Bonus Tip:
You can also use Custom Format:
Go to Format Cells → Custom
Type:
dd-mm-yyyy (For 29-07-2025)
mmmm dd, yyyy (For July 29, 2025)
ddd, dd-mmm-yy (For Tue, 29-Jul-25)