Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to enter and use Hijri date in Microsoft Excel 2003
Article ID: 871138 - View products that this article applies to.
NoticeImportant 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:
(http://support.microsoft.com/kb/256986/ )Description of the Microsoft Windows Registry
In Microsoft Excel 2003, to use the date in Hijri Format some settings are needed to be applied.
The following steps show how we can custom the date in the cells, to be entered as Gregorian format and interpreted in Hijri format, also we will describe how we can enter a date in Hijri format in a cell.
Type a date in Gregorian format and have Excel interpret it as Hijri date:
Type a date in a cell in Hijri format.
The following method will work only on Arabic Office SKU.
To enable this method for non Arabic SKU’s; you will need to add the following registry key:
Value = xl9_hijri
Value Type = DWORD
Value Data = 0
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 (this is Gregorian date 1/1/2000). If the cell is unformatted, it will be assigned the number format 'B2m/d/yyyy' and the value will be displayed as '9/25/1420' Note Your regional settings affect how Excel recognizes the day, month and year parts of the value entered. For example, when using English (United States) regional settings, you should enter the Hijri value as 'a9/25/20'. When using Arabic (Egypt) regional settings, you should enter the Hijri value as 'a25/9/20' Additional keywords