Home > IT Answers > convert general dates to yyyy/mm/dd
M5305
20 pts.
 convert general dates to yyyy/mm/dd
convert dates from general format to date format
My list of dates has the year month and day, in one string of numbers. I need to seperate them so they are month, day and year.

Software/Hardware used:
ASKED: July 23, 2009  8:52 PM
UPDATED: July 24, 2009  8:18 AM
RELATED QUESTIONS
Answer Wiki:
I am using Word 2007. I found a possible solution in Excel help - datevalue function, however, I cannot figure out how to transfer the formula into my spread sheet. Thanks for helping me.
Last Wiki Answer Submitted:  July 23, 2009  10:20 pm  by  M5305   20 pts.
All Answer Wiki Contributors:  M5305   20 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You will need to specify in what software you want to do this.

carlosdl
 63,535 pts.
 

You will not able to tranfer the formula to MS Word 2007. You can follow the mentioned below instructions.

Copy the data from MS Word to MS Excel.
Perform the conversion using TEXT to Column or Year(), Month, Day() function as required.
then copy past the values from MS Excel to Word.

I am not denying the fact that there can be better solutions to this problem. But with available informationi this is only solutions I can think about as of now.

Regards,
Sarfaraz Ahmed
Microsoft Excel help

Findsarfaraz
 1,395 pts.