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).
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:
Update: Here is the animated gif showing it working after applying the solution of mahmoud elgebaly
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)