date format code in national language version

[Stefi]

Hi All,

We use Excel2003 national language (Hungarian) version. Date format codes
(y,m,d) are used in national language versions translated to their national
language equivalents (in our case é,h,n). On one of our computers something
happened, we couldn't detrmine any specific reason, and é,h,n has been reset
to the original English values y,m,d.

What happened and how can we restore the national language equivalents?

Regards,
Stefi

 

[Suleman Peerzade]

Hi Stefi,

You can select the entire sheet goto Right Click on the mouse Format cells.
In format cells select the date catagory and below the type of date you will
find location. Please select hungarian.
The workbook will be restored as desired.

 

[Stefi]

Hi Suleman,

Thank you for yor response but checking the location we found that it was
Hungarian. We made some tests and found that changing location doesn't effect
date format codes. Changing location modifies only the display style of
dates, e.g. order of year, month, date, or names of months and days.

Any further idea?

Regards,
Stefi


„Suleman Peerzade†ezt írta:

 

[Bob Phillips]

Check you Regional Settings in the control panel, they might be set to
English.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Stefi]

Thank you for your response, Bob, I checked Regional Settings and it was set
to Hungarian. It's a very strange thing: date formats are shown in Hungarian
style (I mean order of year, month, day, date separator), but date format
codes in the custom format window are y,m,d instead of é,h,n.

Any further idea?

Regards,
Stefi


„Bob Phillips†ezt írta: