0

As you can see below I am making a GPS Tracking report here

The first column shows where the car stopped at which needs to be in Arabic while the stop duration should be in English.

It's difficult to just switching from one language to another so I would like the first column to be automatically in Arabic and second one in English.

Is this possible?

enter image description here

DavidPostill
  • 162,382
Akrm Zaki
  • 3
  • 1

1 Answers1

0

Since the keyboard input / language bar is controlled at system level (e.g. by Windows), I don't think you can set it per cell like you want.

Perhaps if you are willing to add VBA code to your spreadsheet and save it as a macro enabled .xlsm file, you can trigger the language bar toggle via a dll call within the selection change event. See here for a similar question. Though I'm guessing this isn't worth the effort.

As an alternate solution, you can enter your location and times using the arabic keyboard only, then use a formula to replace arabic/delimiter characters with H and M. E.g. enter 8:5;-54;-54; then in the next column type a formula =SUBSTITUTE(SUBSTITUTE(B2, ":", "H"), ";", "M").