Type Arabic text and numbers in excel sheet

Question

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

nikolinode · Answer

M0stqfa&nbsp;To enable context typing for Arabic text and numbers in Excel, you can change the text direction and enable the right-to-left option for the entire sheet.Here's how you can do it:Select the entire worksheet by clicking on the select all button at the top-left corner of the sheet (the button with a triangle pointing down and to the right).Right-click on any selected cell and choose "Format Cells" from the context menu.In the Format Cells dialog box, go to the Alignment tab.In the Text Control section, select the option "Right-to-left" under the Text direction drop-down menu.Click OK to apply the changes.By enabling the right-to-left text direction for the entire sheet, you can enter Arabic text and numbers in their proper context, with Arabic letters and Arabic numerals aligned correctly.Please note that this setting will affect the entire worksheet, so make sure it's what you want for the entire sheet. If you have specific sections within the sheet where you want to type in a different text direction, you can select those specific cells or ranges and apply the formatting individually.&nbsp;You can switch between different keyboard layouts using the language bar or keyboard shortcuts specific to your operating system.Here are the keyboard shortcuts commonly used to switch between keyboard layouts or input languages in different operating systems:Windows:To switch between languages: Left Alt + ShiftTo cycle through installed keyboard layouts: Left Alt + Shift or Ctrl + ShiftMac:To switch between languages: Command + SpaceTo cycle through installed keyboard layouts: Control + Space or Option + SpaceLinux (GNOME desktop environment):To switch between languages: Super (Windows key) + SpaceTo cycle through installed keyboard layouts: Super (Windows key) + Space or Ctrl + SpacePlease note that these shortcuts may vary depending on your specific operating system configuration or any customizations you have made. It's always a good idea to check your system settings or keyboard preferences for the exact shortcuts applicable to your setup.

umtkyn · Answer

hi,&nbsp;i have the same problem. below reply didnt help me. could you solve it ?&nbsp;https://imgur.com/uiNGVuu&nbsp;&nbsp;M0stqfa&nbsp;

nikolinode · Answer

umtkyn&nbsp;Maybe these links will help you more.Type Arabic text and numbers in excel sheet1Type arabic text and numbers in excel sheet 2They can be seen on the right when opening the message.

umtkyn · Answer

thanks for the fast reply...first link is this thread...the second one i have already but not no result...

nikolinode · Answer

umtkyn&nbsp;My knowledge on this topic is limited (to put it mildly). But that didn't stop me from doing some research for them on the Internet.Here are the links I found about it:Change numbers into Arabic wordsArabic numerals in MS Excel?Arabic numbers Arabic Numbers issue&nbsp;Additionaly, here are some steps, how you can do it maybe with diferend setup:1. Enable Arabic Language: If Arabic is not already enabled on your system, you may need to add it as a language option in your Windows settings. To do this:Go to the "Control Panel" on your computer.Select "Clock and Region" or "Region and Language" (the exact name may vary depending on your Windows version).Click on "Language" or "Add a language."Search for "Arabic" and add it to your language list.Set Arabic as the default language if desired.2. Switch Input Language: Once Arabic is enabled, you can switch the input language to Arabic while typing in Excel. You can do this by:Clicking on the language indicator in the taskbar (usually located at the bottom-right corner of the screen) and selecting "Arabic" from the list of available languages.Alternatively, you can use the keyboard shortcut Alt + Shift to switch between input languages.3. Type Arabic Text: After switching to the Arabic input language, you can start typing Arabic text directly into Excel cells. The text will be entered from right to left, which is the standard direction for Arabic script.4. Type Arabic Numbers: Arabic numbers can be typed the same way as English numbers. However, if you prefer to use Arabic-Indic numerals (٠١٢٣٤٥٦٧٨٩) instead of Western numerals (0-9), you may need to change the number format:Select the cells containing numbers that you want to format.Right-click and choose "Format Cells."In the "Format Cells" dialog box, go to the "Number" tab.Under "Category," select "Custom."In the "Type" field, enter 0 for Arabic-Indic numerals.Click "OK" to apply the formatting.With these steps, you can easily type Arabic text and numbers in Microsoft Excel. Remember to switch back to your default input language after finishing typing in Arabic if necessary.&nbsp;&nbsp;My answers are voluntary and without guarantee!&nbsp;Hope this will help you.&nbsp;Was the answer useful? Mark as best response and like it!This will help all forum participants.

Forum Discussion

Type Arabic text and numbers in excel sheet

5 Replies

Resources