Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
How to write context numbers in excel
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:
- Setting the Digit substitution to Context
- Setting the User Locale to Arabic (any country)
- Set the Text Direction in the cell to be Right-to-Left
The following steps will describe how we can apply these setting:
- Set the Digit substitution to Context, by following the next steps:
- Go to Control Panel
- Open Regional and Language Option (Regional Option in windows 2000)
- In the Numbers tab
- Set the Digit substitution to Context
- Set User Locale to Arabic (any country), following the next steps:
- Go to Control Panel
- Open Regional and Language Option (Regional Option in windows 2000)
- -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:
- In the Formatting toolbar menu, click the down arrow next to the Text Direction button. From the dropdown menu select Right-to-Left.
- From the main menu, click on Format and select Cells
in the Text Direction list on the Alignment tab, Select Right-to-Left
Article ID: 823002 - Last Review: August 25, 2008 - Revision: 1.1
APPLIES TO
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
| kblangsupparabic kbhowto KB823002 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate