Cell gets formatted as Hijri date (Arabic date)

  • Thread starter Thread starter ashkaan57
  • Start date Start 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.
 
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
 
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 -
Click to expand...

Thanks for the reply.
It did not work.
 
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.
 
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...
 
Back
Top