Cell gets formatted as Hijri date (Arabic date)

[ashkaan57]

Hi,
on some of the PCs at work, when the user enters a value starting with
'a' or 'A' followed bya number from 1 to 12, it gets displayed as
Arabic text representiing the month. When I look at the formatting of
the cell, it shows as Custom with type set as "B2d-mmm". Deleting the
type has no effect, it just comes back.

Microsoft KB 871138 (http://support.microsoft.com/kb/871138) shows how
to enter Arabic dates:
"To enter Hijri date, type A or a in front of the date entry
For example, you can enter the short date 'a9/25/20', which will be
interpreted as Hijri date 9/25/1420 ...."

How can I resolve this?
I want A5 to be A5 not the fifth month in Arabic.

This does NOT happen on all workstations running the same version of
Excel (2003).

Thanks.

 

[DILipandey]

Hi Ashkaan,

Please check if there is some "Auto Correct" option is set on some of the
PCs. Go to Tools - AutoCorrect Options.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[ashkaan57]

Hi Ashkaan,

Please check if there is some "Auto Correct" option is set on some of the
PCs.  Go to Tools - AutoCorrect Options.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India









- Show quoted text -

Thanks for the reply.
It did not work.

 

[Dave Peterson]

http://support.microsoft.com/?id=812385
Shows a registry tweak to turn it off.

The KB article you included showed how to turn it on. It's too bad they didn't
include a link to that other article or at least include the value to turn it
off:

HKCU\Software\Microsoft\Office\11.0\Excel\Options\
Value = xl9_hijri
Value Type = DWORD
Value Data = 0

Value Data = 1
will turn it off

The key in the registry will changed depending on the version of excel that
you're using.

 

[ashkaan57]

Thanks Dave, you're a life saver!

http://support.microsoft.com/?id=812385
Shows a registry tweak to turn it off.

The KB article you included showed how to turn it on.  It's too bad they didn't
include a link to that other article or at least include the value to turn it
off:

HKCU\Software\Microsoft\Office\11.0\Excel\Options\
Value = xl9_hijri
Value Type = DWORD
Value Data = 0

Value Data = 1
will turn it off

The key in the registry will changed depending on the version of excel that
you're using.











--

Dave Peterson- Hide quoted text -

- Show quoted text -