Forum Discussion
Type arabic text and numbers in excel sheet
Excel used to have advanced setting that allow context typing in the whole sheet. i.e. when I write Arabic alphanumeric it is writing Arabic letters with English numbers.
| إجمالي قيمة العقد 1500000 الف جنيه |
Instead of
any help with regards to changing context for the whole sheet!?
3 Replies
I added this keyboard to my device and it helped me with that.
Use it to write the numbers only, and use the normal arabic keyboard to write the rest of the text.
And note that it didn't work with the numpad, it worked only with the numbers row at the top - the one that has the special characters !@#$%^&*()
TarekYounesHi TarekYounes,
You can change the number formatting as below to read it as Arabic Number
[$-ar-SA,206] #,##0.00Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more
- Well. I am not seeking a cell by cell formating. Still this will not solve having alphanumeric cell mixining text and numbers in the sma ecell.
