Change existing date/s format in excel 2003 in bulk level?
|
demo 23 Dec 2008 03:03am Hi, i need to solution urgently.I got some excel files. I need to export the files to database one by one. i am using MySQL database. But in those excel files, the date is in the format of MM/DD/YYYY . but MySQL does not allow this format to export. It supports YYYY-MM-DD format. How can i export the date. There is lot of different sample dates, so that its take more time to change manually. is there any solution for this. Thanks in advance. Any answer can be kindly accepted. |
Answers
|
demo 23 Dec 2008 03:08am You can select multiple cells and apply the same format to all of them. Say if all the dates are in one column you can click the column header to select the whole column or just use your mouse to dragselect the ones in the column. If all the dates aren't in one column/row could you try to 'Sort' that data so that it is. Hope that helps =] |
|
demo 23 Dec 2008 03:10am Go to citytechforum.com and for a small fee someone will answer your queston. John |
Related
Submit Answer
You must be logged in to post an answer. Please Login or Register.
Powered by phpMyAnswers.