Type arabic text and numbers in excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1531016%22%20slang%3D%22en-US%22%3EType%20arabic%20text%20and%20numbers%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531016%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20used%20to%20have%20advanced%20setting%20that%20allow%20context%20typing%20in%20the%20whole%20sheet.%20i.e.%20when%20I%20write%20Arabic%20alphanumeric%20it%20is%20writing%20Arabic%20letters%20with%20English%20numbers.%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22231%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22231%22%3E%D8%A5%D8%AC%D9%85%D8%A7%D9%84%D9%8A%20%D9%82%D9%8A%D9%85%D8%A9%20%D8%A7%D9%84%D8%B9%D9%82%D8%AF%201500000%20%D8%A7%D9%84%D9%81%20%D8%AC%D9%86%D9%8A%D9%87%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22numbers.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206242i9DDB569AAB0FB7D4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22numbers.png%22%20alt%3D%22numbers.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3Eany%20help%20with%20regards%20to%20changing%20context%20for%20the%20whole%20sheet!%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1531016%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531517%22%20slang%3D%22en-US%22%3ERe%3A%20Type%20arabic%20text%20and%20numbers%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531517%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732686%22%20target%3D%22_blank%22%3E%40TarekYounes%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20change%20the%20number%20formatting%20as%20below%20to%20read%20it%20as%20Arabic%20Number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%5B%24-ar-SA%2C206%5D%20%23%2C%23%230.00%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Snag_6683570b.png%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206262i8C37D6920A960738%2Fimage-dimensions%2F640x421%3Fv%3D1.0%22%20width%3D%22640%22%20height%3D%22421%22%20title%3D%22Snag_6683570b.png%22%20alt%3D%22Snag_6683570b.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531530%22%20slang%3D%22en-US%22%3ERe%3A%20Type%20arabic%20text%20and%20numbers%20in%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531530%22%20slang%3D%22en-US%22%3EWell.%20I%20am%20not%20seeking%20a%20cell%20by%20cell%20formating.%20Still%20this%20will%20not%20solve%20having%20alphanumeric%20cell%20mixining%20text%20and%20numbers%20in%20the%20sma%20ecell.%3C%2FLINGO-BODY%3E
Occasional Contributor

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 

numbers.png

any help with regards to changing context for the whole sheet!?

 

2 Replies

Hi @TarekYounes,

 

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

 

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

 

Snag_6683570b.png

 

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

 

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.