date format in excel not in line with control panel regional setti
 

I am running office professional 97 on windows XP platform and have a problem
with excel date formats. The control panel regional settings in windows are
set correctly to English ( united Kingdom ) with short date format of
DD/MM/YYYY.
when I apply format cells in excel and select the date category the date
formats presented appear to be in US format i.e. MM/DD/YYYY. and if applied
to cells, the US date format is displayed.

I have tried uninstalling and reinstalling excel, but problem still persists.

In Access, the date formats are in the correct UK format and not US.

Are there any obvious reasons that Excel is ignoring the Windows regional
settings ?
are there any settings within Excel that can bring this in line ?

I know the obvious answer is going to be upgrade to Office XP professional,
but I can't afford the funds at the moment and Office 97 professional does
everything I want to at the moment.

Have a look under the Custom formats for the DD/MM/YYYY format and use that.
Alternatively, you can use the custom format codes to make your own date
formats. See http://www.allaboutoffice.co.uk/excustf.htm for more
information.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"GrahamR" wrote:

I am running office professional 97 on windows XP platform and have a problem
with excel date formats. The control panel regional settings in windows are
set correctly to English ( united Kingdom ) with short date format of
DD/MM/YYYY.
when I apply format cells in excel and select the date category the date
formats presented appear to be in US format i.e. MM/DD/YYYY. and if applied
to cells, the US date format is displayed.

I have tried uninstalling and reinstalling excel, but problem still persists.

In Access, the date formats are in the correct UK format and not US.

Are there any obvious reasons that Excel is ignoring the Windows regional
settings ?
are there any settings within Excel that can bring this in line ?

I know the obvious answer is going to be upgrade to Office XP professional,
but I can't afford the funds at the moment and Office 97 professional does
everything I want to at the moment.

Thanks, that solves the problem. but it is still niggling why Excel is not in
line with regional settings. I will just have toaccept it as a 'feature'

"Andrea Jones" wrote:

Have a look under the Custom formats for the DD/MM/YYYY format and use that.
Alternatively, you can use the custom format codes to make your own date
formats. See http://www.allaboutoffice.co.uk/excustf.htm for more
information.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"GrahamR" wrote:

I am running office professional 97 on windows XP platform and have a problem
with excel date formats. The control panel regional settings in windows are
set correctly to English ( united Kingdom ) with short date format of
DD/MM/YYYY.
when I apply format cells in excel and select the date category the date
formats presented appear to be in US format i.e. MM/DD/YYYY. and if applied
to cells, the US date format is displayed.

I have tried uninstalling and reinstalling excel, but problem still persists.

In Access, the date formats are in the correct UK format and not US.

Are there any obvious reasons that Excel is ignoring the Windows regional
settings ?
are there any settings within Excel that can bring this in line ?

I know the obvious answer is going to be upgrade to Office XP professional,
but I can't afford the funds at the moment and Office 97 professional does
everything I want to at the moment.

Hello Graham

I have the same DMY versus MDY problem in Excel 2000. I do not understand
why Excel isn't complying with the date format per the Regional Settings. I
was wondering if you ever resolved this issue?

Regards

JT

"GrahamR" wrote:

Thanks, that solves the problem. but it is still niggling why Excel is not in
line with regional settings. I will just have toaccept it as a 'feature'

"Andrea Jones" wrote:

Have a look under the Custom formats for the DD/MM/YYYY format and use that.
Alternatively, you can use the custom format codes to make your own date
formats. See http://www.allaboutoffice.co.uk/excustf.htm for more
information.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"GrahamR" wrote:

I am running office professional 97 on windows XP platform and have a problem
with excel date formats. The control panel regional settings in windows are
set correctly to English ( united Kingdom ) with short date format of
DD/MM/YYYY.
when I apply format cells in excel and select the date category the date
formats presented appear to be in US format i.e. MM/DD/YYYY. and if applied
to cells, the US date format is displayed.

I have tried uninstalling and reinstalling excel, but problem still persists.

In Access, the date formats are in the correct UK format and not US.

Are there any obvious reasons that Excel is ignoring the Windows regional
settings ?
are there any settings within Excel that can bring this in line ?

I know the obvious answer is going to be upgrade to Office XP professional,
but I can't afford the funds at the moment and Office 97 professional does
everything I want to at the moment.