How to write context numbers in excel

Summary

The Article Explains how to type Arabic and English numbers in Excel Cells.

The following settings are needed to use context digits in Microsoft Excel:

The following steps will describe how we can apply these setting:

Set the Digit substitution to Context, by following the next steps:
1. Go to Control Panel
2. Open Regional and Language Option (Regional Option in windows 2000)
3. In the Numbers tab
4. Set the Digit substitution to Context
Set User Locale to Arabic (any country), following the next steps:
1. Go to Control Panel
2. Open Regional and Language Option (Regional Option in windows 2000)
3. -In General tab, change your locale (Standards and Formats in Windows XP), to Arabic (any country), for example: Arabic (Saudi Arabia)
Set the Text Direction for cells Select range of cells where you want to write Hindi numbers and do one of the following:
1. In the Formatting toolbar menu, click the down arrow next to the Text Direction button. From the dropdown menu select Right-to-Left.
2. From the main menu, click on Format and select Cells in the Text Direction list on the Alignment tab, Select Right-to-Left

Keywords: KB823002, kbhowto, kblangsupparabic

Article Info