DATE FORMATTING IN dd/mm/yyyy [Solved/Closed]
nisha - - Latest reply: appu - Jul 23, 2013 at 07:34 AM
Related:
- Forcing date format (dd/mm/yyyy) using data validation
- How to add slash in date in excel - Best answers
- How to change date format in excel to dd/mm/yyyy - Best answers
- Excel date format dd/mm/yyyy - How-To - Excel
- Excel date format dd/mm/yyyy not working ✓ - Forum - Excel
- Change date format dd.mm.yyyy to dd/mm/yyyy ✓ - Forum - Excel
- Php validate date format dd/mm/yyyy - How-To - PHP
- How to change date format in excel to dd mm yyyy hh mm ss - Forum - Excel
7 replies
Best answer
Hi , please use data text to columns to seprate the values and the use the date function to create the format you desire.
A few words of thanks would be greatly appreciated. Add comment
has helped 2750 users this month
If it is in YYYYMMDD format
select the column go to DATA TAB
select text to columns
give two next and in third one select date radio button and select YMD format this will be converted to D/M/YYYY format dont get panic
now select the same row with d/m/yyyy format and right click and select fomat cells in that select date in locale select english(u.k) browse for any date option on top and select it....
simple now YYYYYMMDD converted to YYYY-MM-DD
Balaji Raghunathan
select the column go to DATA TAB
select text to columns
give two next and in third one select date radio button and select YMD format this will be converted to D/M/YYYY format dont get panic
now select the same row with d/m/yyyy format and right click and select fomat cells in that select date in locale select english(u.k) browse for any date option on top and select it....
simple now YYYYYMMDD converted to YYYY-MM-DD
Balaji Raghunathan
I want to know how shall I change the date in Microsoft SQL server database.
Partha.S.Singha