Microsoft KB Archive/812385

= XL2002: Cells Automatically Format with Hijri Date Format When You Type &quot;a-&quot; Before a Number =

Article ID: 812385

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



Note This article discusses complex scripts functionality. Complex scripts functionality is available when you use the Office Language Settings tool to enable a language, such as Arabic or Hebrew, that requires this functionality. For more information about multilingual features, click Microsoft  Help on the Help menu, type multilingual features in the Office Assistant or the Answer Wizard, and then click Searchto view the topics that are returned.



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you create a new workbook in Excel 2002, and you type an expression of the form a1- in a cell, where  is any number in the range from 1 to 99, the cell automatically formats with an Arabic date format.



CAUSE
This behavior occurs because Excel 2002 interprets these strings as dates in the Hijri calendar.



RESOLUTION
To resolve this behavior, you must set a registry value, so that Excel does not interpret such strings as dates in the Hijri calendar. To do this:

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.  Quit all Microsoft Windows programs, including Microsoft Excel 2002. Click Start, and then click Run. In the Open box, type regedit, and then click OK. Locate and then select the following registry key:

 

 On the Edit menu, click New, and then click DWORD Value. Type xl9_hijri, and then press ENTER.</li> On the Edit menu, click Modify.</li> Type 1, and then click OK .</li> On the Registry menu, click Exit .</li></ol>

When you restart Excel 2002 after you set this registry key, the program will no longer interpret these strings as Hijri dates. When this key is not present, Excel functions as if the key were set to 0 and automatically interpret the entered values as Hijri dates.

<div class="moreinformation_section">

Keywords: kbbug KB812385

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.