Forum Discussion

TarekYounes's avatar
TarekYounes
Copper Contributor
Jul 18, 2020

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.  إجمالي قيمة العقد 15000...
excel
office 365
ExcelExciting's avatar
ExcelExciting
MVP
Jul 19, 2020

Hi TarekYounes,

 

You can change the number formatting as below to read it as Arabic Number

 

[$-ar-SA,206] #,##0.00

 

 

Regards, 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

 

  • TarekYounes's avatar
    TarekYounes
    Copper Contributor
    Jul 19, 2020
    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.

Resources