Search code examples
excelexcel-formulaarabic

Excel formulas to convert between Western Arabic & Eastern Arabic numerals?

I'm working on an Excel project that requires I convert between numbers as follows

1 <--> ١
2 <--> ٢
3 <--> ٣
4 <--> ٤

According to this wikipedia page the ones on the left are called "Western Arabic" and the ones on the right are called "Eastern Arabic". So, put another way, I want formulas that convert between Western and Eastern Arabic numerals.

When I entered the first few Eastern Arabic numerals into a series of cells, I was able to drag down as usual to produce the others, as shown in cells E2:E16 below. But I need formulas for more advanced use.

enter image description here

Solution

  • You can use the following custom format: [$-,206]0

    If you want to use a formula then:

    =TEXT(A1,"[$-,206]0")

    enter image description here

    And back:

    =--B1

    enter image description here