Change existing date/s format in excel 2003 in bulk level?

Question

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.

Answer 1

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 =]

Answer 2

you just need to change the format of the date?

theres a few things you could try

open a new blank sheet:



1. change the format

- if A1 has the date 05/07/2008

- right click on A1

- click format cells...

- click custom

- in the Type box type



yyyy-mm-dd



- then you date should be formatted the way you expext it to look.

- unsure if MySQL will accept that or not...because excel stores dates as 5 digit numbers.

- if you copy A1

- right click on cell B1

- click paste special...

- click values

- click ok and you will see the 5 digit number is the "value"



2. the other (probably better) way is convert the date to "text"

- in A2 use the date 05/07/2008

- in B2 copy&paste this formula



=TEXT(A2,"yyyy-mm-dd")



- then copy B2

- right click on C2

- click paste special...

- click values

- click ok

and you will see that the date is now text formatted to the format you want.

you might not even want to put the dashes in the quotes in the text() formula, but its your choice on how you want to see it.



hope one of these helps when you apply it to your real sheet.

with #1 above...you dont need to do anything

with #2 above you need to:

- just copy&paste the formula down the column.

- then do the paste special... over the original dates.

- then just delete the column where you put the formula

Answer 3

I've tried this before for a science project. I made a powerpoint with 2010 exel, but my school had 2007. I opened the powerpoint with 2007, and all the face backgrounds and images weren't there. So the answer is no,you can not open a powerpoint from 2010, on 2007 and have everything perfectly displayed.

Answer 4

Go to citytechforum.com and for a small fee someone will answer your queston.



John