How to Convert Gregorian to Islamic Hijri Dates? & How to Extract Islamic Months & Years from a Islamic Date in #Excel ? Solution 1: Custom Formatting | [$-,106]DD | [$-,106]MMM | [$-,106]YYYY Solution 2: =TEXT(B6,"[$-,106]MMM") $ indicates that it's a locale-specific format. 106 is a Locale ID (LCID). LCID 106 represents the Arabic (Islamic) calendar. This tells excel to use the Islamic calendar for this cell. - (Hyphen Sign ) tells excel to use the default Calendar type for that Locale. | Exce