Related:
- Mm/dd/yy AND dd/mm/yy AND mm-dd-yy AND dd-mm-yy in one column
- Dd mm yy format in excel - Guide
- How to change date format from yyyymmdd to mm/dd/yy in Excel? ✓ - Forum - Excel
- Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format ✓ - Forum - Excel
- Excel date format dd/mm/yyyy not working ✓ - Forum - Excel
- Convert mm/dd/yyyy to mm/yyyy in excel - Forum - Excel
1 reply
ArashMan
Jan 21, 2015 at 01:16 AM
- Posts
- 41
- Registration date
- Monday December 15, 2014
- Status
- Member
- Last seen
- February 18, 2015
Jan 21, 2015 at 01:16 AM
Dear Viktoria
first yous should select them all
then go to format cells. after that in first tab which is number select Date. and then select which type do u want,
i hope that is what you are looking for.
first yous should select them all
then go to format cells. after that in first tab which is number select Date. and then select which type do u want,
i hope that is what you are looking for.
Jan 21, 2015 at 12:34 PM
Thanks for your quick reply. I tried what you suggested, but not all the formats change, some stay the same..
Jan 21, 2015 at 04:00 PM
dd-mm-yyyy or mm-dd-yyyy
01/06/2015 could be either. Is it January 6th or June 1st?
If the can be separated into types then a pretty simple string manipulation routine would be able to set them to the same.
Jan 23, 2015 at 11:02 AM
Jan 23, 2015 at 12:20 PM
01/06/2015 (dd/mm/yyyy)
And you need to change it to be 06/01/2015 (mm/dd/yyyy)
Then this will switch the dd and mm parts
=MID(A1,4,3) & MID(A1,1,3) & MID(A1,7,4)
This assumes that each part being switched has two digits, 01 and not 1 because then it wont work.