Previously I had post one method of doing this, show me.
Today I would like to share other way to perform this action
1. Select cell range (data range where we want to convert)
2. Go to Menu - Data, select "Text to column", the working box as follow;
3. Select "Delimited", press Next
4. Result
The next now splitted to 3 column which consists of day, month & year value in each cell.
example 11.05.2009 will be splitted to 11, 5 and 2009
5. Use excel "Date" function, date(year,month,day)
Set day to 11, month to 5 and year 2009
6. The result was a date format which could be change to follow date format
i.e (format.. cells...date.. select format that we required)
No comments:
Post a Comment