Type arabic text and numbers in excel sheet

[TarekYounes]

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!?

[#2]

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

[#3]

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.