Cell gets formatted as Hijri date (Arabic date)

A

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.
 
D

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.
 
A

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 -
Click to expand...
 
Top