Guest Peter Posted September 10, 2007 Posted September 10, 2007 I have already changed the regional setting to Australia but still get American Date in Excel. Someone has suggested that it might be problem with Locale. How can I get it changed ? Thanks Peter
Guest Smirnoff Posted September 10, 2007 Posted September 10, 2007 Re: How can I change the Locale ? "Peter" <Peter@discussions.microsoft.com> wrote in message news:upmsyB48HHA.4200@TK2MSFTNGP04.phx.gbl... > I have already changed the regional setting to Australia but still get > American Date in Excel. > > Someone has suggested that it might be problem with Locale. How can I > get it changed ? > > Thanks > Peter > > Maybe a silly question but when you changed regional settings, did you click Apply before OK?
Guest Newbie Coder Posted September 10, 2007 Posted September 10, 2007 Re: How can I change the Locale ? Peter, START | CONTROL PANEL | REGIONAL SETTINGS | GENERAL tab Choose your locale (ENGLISH (AUSTRALIA)) there & click SET DEFAULT Change the Input Locale too: If you have more than one language listed make Aussie English the default, reboot if its not the default language previously then go back in & delete the other language. -- Newbie Coder (It's just a name) "Peter" <Peter@discussions.microsoft.com> wrote in message news:upmsyB48HHA.4200@TK2MSFTNGP04.phx.gbl... > I have already changed the regional setting to Australia but still get > American Date in Excel. > > Someone has suggested that it might be problem with Locale. How can I get > it changed ? > > Thanks > Peter > >
Guest Ken Blake, MVP Posted September 10, 2007 Posted September 10, 2007 Re: How can I change the Locale ? On Mon, 10 Sep 2007 09:32:15 +0100, "Smirnoff" <someone@nospam.invalid> wrote: > > > "Peter" <Peter@discussions.microsoft.com> wrote in message > news:upmsyB48HHA.4200@TK2MSFTNGP04.phx.gbl... > > I have already changed the regional setting to Australia but still get > > American Date in Excel. > > > > Someone has suggested that it might be problem with Locale. How can I > > get it changed ? > > > > Thanks > > Peter > > > > > Maybe a silly question but when you changed regional settings, did you > click Apply before OK? No, that isn't necessary. OK includes applying. The difference between OK and Apply is 1. Apply applies the change and keeps the dialog box open. 2. OK applies the change and closes the dialog box. -- Ken Blake, Microsoft MVP Windows - Shell/User Please Reply to the Newsgroup
Recommended Posts