Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regional Settings with Date
I wonder if anyone can help me with this as it's driving me mad.
I have Excel 2003 running under Vista Home Premium and everything was fine until a few days ago. I have spreadsheets with dates entered in the following format: Date: 14-Mar-01 - so when I enter 16/11/07 it appears in the cell as 16-Nov-07. The locale is: English (United Kingdom) A couple of days ago I installed a program which needs to change my regional settings to US while it is running and then changes them back when I exit. Everything works fine and all the regional settings are changed back to UK after closing this software. However, in Excel, all new sheets now open up with the date set to English (US). Even if I format the cell to English (UK), I canot enter the dates as I did before. If I now enter 16/11/07 it just stays in this format. I have to enter the date in US format, 11/16/07 before it will change to 16-Nov-07, even thought the cell is set to UK format. I am sure the software I installed has changed some variable but how do I change it back? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regional Settings with Date
Just to add, this only happens on my user account, all other user
accounts are fine and you can enter the date as 16/11/07 and it comes up as 16-Nov-07. It seems all settings on Excel have been changed to US even though my regional settings are set to UK. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regional Settings with Date
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regional Settings with Date
On 19 Nov, 23:53, Ron Rosenfeld wrote:
On Mon, 19 Nov 2007 15:18:13 -0800 (PST), wrote: Just to add, this only happens on my user account, all other user accounts are fine and you can enter the date as 16/11/07 and it comes up as 16-Nov-07. It seems all settings on Excel have been changed to US even though my regional settings are set to UK. When you write "regional settings", are you referring to the settings in Excel, or to the settings in the Windows Control Panel Regional settings. The behaviour you describe is what would happen if the Windows Control Panel Regional settings got set to US settings (or the short-date format, anyway). --ron Sorry, the regional settings I referred to are the windows settings, under Control Panel. I have tried changing this to US and back to UK again but it makes no difference. Both the long date and short date are set correctly to what I want under Control Panel, Regional Settings but in Excel I still have to type the date in back-to-front in order for it to recognise it as a date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
regional settings | Excel Worksheet Functions | |||
Problems with Turkish regional settings | Excel Discussion (Misc queries) | |||
Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) | |||
Regional Settings | Excel Discussion (Misc queries) | |||
how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) |