excelvbawindowsarabic-support

How to type Eastern Arabic numerals and Arabic letters in the same Excel cell in Windows?


I have an Excel VBA project that needs to run on both Mac OS and Windows 10. The program needs users to type in Eastern Arabic numerals and Arabic letters into the same cell. As my animated gif demonstrates (click for detail), I know how to do this on Mac OS (shown at top), but I can't figure out how to do it in Windows 10 (shown at bottom).

enter image description here

Notice that I switch between languages using the menubar/taskbar, and in each case it works fine for letters. The problem is that Windows Excel won't let me type the Eastern Arabic numerals into a cell as I do on Mac OS.

In other words, I want what happens in cell B4 on the Mac (top) to happen in cell C4 on Windows (bottom).

Please note:

1) I need users to actually type the Eastern Arabic numerals into a cell

2) I have the language pack for Arabic installed on Windows 10

3) Because the terminology can be confusing, here is a helpful table:

enter image description here

Update: Here is the animated gif showing it working after applying the solution of mahmoud elgebaly

enter image description here


Solution

  • on windows operating sys change the region and language settings in control panel to arabic then go to excel ribbon tab (home) group (alignment) select (right-to-left direction)