Hi,
In the attached sheet, jsinfo_new_2, in column H, dob, Date of Birth of applicants is present in different formats. Could anyone tell me if it is possible to change the format of these data into a single format?
Thanks!
Abhinav
Hi,
In the attached sheet, jsinfo_new_2, in column H, dob, Date of Birth of applicants is present in different formats. Could anyone tell me if it is possible to change the format of these data into a single format?
Thanks!
Abhinav
Do this..
- Select column D
- Data -- text to columns -- delimited by -- next -- tab -- next -- date -- DMY -- Finish
Life's a spreadsheet, Excel!
Say thanks, Click *
Hey it worked! Thanks!!
nolonger required
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks