Date
12112013
9081970
12121936
4091964
Please look the above 4 dates.Here,take an example i.e.9081970.Last 4 digits are 'Year' i.e.1970,next from right to left 2 digits are 'Month' i.e.08 ( August) and rest of date i.e.'9'.
Now I want this format of above all:-
Desired
12.11.2013
09.08.1970
12.12.1936
04.09.1964
Is it possible through excel formula?
Bookmarks