Date formatting in dd/mm/yyyy
[Solved/Closed]
Related:
- Today's date in slash format
- How to add slash in date in excel - Best answers
- How to convert date from dash to slash format in excel - Best answers
- How to convert date from dot to slash format in excel ✓ - Forum - Excel
- How to change date format with slash in excel - How-To - Excel
- Excel change date format from dot to slash ✓ - Forum - Excel
- Format write protected usb - How-To - USB
- How to change time format in whatsapp - How-To - Mobile
5 replies
NICK
Hi,
Good luck.
- Just use replace function under EDIT/REPLACE or press Ctrl+H.
- Replace the . (dot) by a forward slash / .
- Then you will be able to change the format.
- If not, copy the result and paste it again in the column to force Excel to recalculate cells.
Good luck.
Report
Alison M
This worked best for me - it seems like a regular issue!
Report
Barbara
This worked great ! Thank you so much !
Report
appu
gud solution
john
Hi , please use data text to columns to seprate the values and the use the date function to create the format you desire.
Balaji
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
