Found this in Excel Help:
"Changing the default country/region changes the standard settings for
numbers, currencies, time, and date to those most commonly used for that
country/region.
Microsoft Windows XP
In the Control Panel, click Date, Time, Language, and Regional Options.
Click Regional and Language Options, and then click the Regional Options
tab.
Select the country/region you want to use from the list under Standards
and formats.
Click OK, and then restart your program.
Microsoft Windows 2000
In the Control Panel, double-click Regional Options.
Use the Your locale (location) list to select the country/region you
want to use as the default.
If you don't see the item you want, first select the check box next to
the appropriate language in the Language settings for the system box.
Click OK, and then restart your program.
Note When you change the country/region, settings, such as the format
for displaying currency and date, may also change. Check all the tabs in
the Regional and Language Options or Regional Options dialog box to make
sure they are correct."
Also noticed in Help that certain date format changes will not be
applied to changes made in Format:
"Change the default date format to display four-digit years
When you change the default date format to a different format by using
this procedure, the display of dates that were previously entered in
your workbook will change to the new format as long as the dates haven't
been formatted by using the Cells command (Format menu)."
Although this refers only to four-digit years format, the last bit may
apply in other cases(CSV?) - (as long as the dates haven't been
formatted by using the Cells command (Format menu)).
"Peter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dear David,
>
> Thank you for your advice. I do post it to Excel Discussion Group but
> there is no reply. A fellow suggests whether it is related to Locale
> so that I post it in this group.
>
> The date appears properly in Excel but when it is saved as CSV file,
> it changes to American Date Format.
>
> Regards
> Peter
>
> "David Webb" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> In Excel, click on Format > Cells > Number tab > Date. Select English
>> (Australia) from the Locale drop-down list.
>>
>> Your question is off-topic for the newsgroup. You would be better
>> served by
>> posting to the microsoft.public.excel newsgroup for any future issues
>> you have
>> with Excel.
>>
>>
>> "Peter" <(E-Mail Removed)> wrote in message
>> news:%23L%23%(E-Mail Removed)...
>>> 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
>>>
>>>
>>
>>
>
>
|
Similar Threads
