Excel date problem

[carderne]

I've got a column of dates in the following format: day/month/year
But when I import them into excel it imports them as: month/day/year

Any idea how I can rectify this?

[HavocXphere]

Change date settings in control panel.

[carderne]

Change date settings in control panel.

Clarify please?

And I'm using Office 07 btw.

[Surv0]

is it not date formatting in the cell itself?
Either that or your system uses the mm/dd/yyyy format
Check your regional settings in control panel.

[TonyA]

In regional settings via control panel change the date format to dd/MM/yyyy

[carderne]

Thanks and thanks. Regional settings seems to be the thing.

[Divestar]

In regional settings via control panel change the date format to dd/MM/yyyy

My computer is set to this format, but excel 2007 still uses yyyy/MM/dd.
Any ideas how I can get this to work?

[greggpb]

Ctrl+shift+3

or you can set the formating on the column as date

right click cell select format cell select date

[bekdik]

If the cell recognizes the value as the correct date, then the data is correctly stored as date. One can then change the cell's display characteristics by setting the format to something like YYYY/MM/DD as a customized format.

[Divestar]

If the cell recognizes the value as the correct date, then the data is correctly stored as date. One can then change the cell's display characteristics by setting the format to something like YYYY/MM/DD as a customized format.

Excell 2007 uses dates as yyyy/MM/dd. My formula is dependant on a date. I can set the cell to display the date as dd/MM/yyyy, but I still need to enter it as yyyy/MM/dd. Everything else on my PC uses the date as dd/MM/yyyy. How can I set excell to also use this date format. Not just in certain cells, but the whole application?

[Divestar]

Excell 2007 uses dates as yyyy/MM/dd. My formula is dependant on a date. I can set the cell to display the date as dd/MM/yyyy, but I still need to enter it as yyyy/MM/dd. Everything else on my PC uses the date as dd/MM/yyyy. How can I set excell to also use this date format. Not just in certain cells, but the whole application?

:D:D:D I found a sollution that worked!!!:


Hello, Kendal

I recently had a similar problem and came across your post. I had an excel sheet which had always had the right formats before, and then suddenly started showing other formats after I installed a certain program. When I checked regional settings in the control panel, it seemed right (all settings were United States). But excel kept defaulting to strangely formatted dates.

I suggest the following, as it worked for me:

Go to "regional and language options" and then "regional options" in the control panel.

Change both dropdowns (under standards and location) to an incorrect setting and apply. Then change back to the correct location and standard setting. This appears to go back to defaults for that setting, rather than retaining any customized locale formats. After I did this my dates in excel were working properly for my US format.

Good luck.

Dan


I hope someone else will also find this useful