I have some data in MS excel where there are dates mentioned in a column in 2 different formats(dd-mm-yyyy & mm/dd/yyyy). How do I make them similar or convert them to mm/dd/yyyy format?
Asked
Active
Viewed 1,175 times
0
-
question is: are they real dates with different formatting ? or just strings representing a date ? – iDevlop Mar 18 '17 at 14:04
-
Are they all right-aligned or left-aligned? Are some right-aligned and some left-aligned? What is your system's regional setting? DMY or MDY? – Mar 18 '17 at 14:09
-
I guess they are strings. If not how to identify so? – Abhishek Patel Mar 18 '17 at 14:09
-
well some of them are left aligned and some are right aligned. The regional setting is DMY – Abhishek Patel Mar 18 '17 at 14:10
1 Answers
0
select the dropdown you would normally select to format the column to a date. Then select the custom option to specify your own formula for the format.
Harriet
- 1,633
- 5
- 22
- 36
-
can you share some sort of visuals? Actually I am new to it @Harriet – Abhishek Patel Mar 18 '17 at 14:07
-
-
Hello @Abhishek - I sincerely hope you have this sorted, but in case you did not: you select the column you want to work with, and you right click and select format cells. Then a dialog will open that will allow you to make changes to the formatting. If you do not find the formatting you are interested in in the Date dialog, then you select Custom, and enter the formula yourself. I hope this helps, if not too late... – Harriet Mar 23 '17 at 10:48