Change numbering language of the Excel context by changing the Windows language

How could we change the numbering language of MS Excel 2010 by changing Windows language

In version 2007 as I can remember we had an option in the advanced options tab that allowed us to do that with setting it as "Context" ,

so it smartly change the numbering system whenever we change the language of Windows .

3 Answers

file - options - language and under choose editing languages add the language you'd like to use. Once it's added, set as default

If you want to convert numeric numbers to Arabic numbers:

1. Select the area of cells that you want to change
2. Press Ctrl+1 for Format Cell
3. Go to Custom and type this code: [$-2060000]0

1. Select the area of the cells that you need to change
2. Press Ctrl+1 using keybard
3. Go to Customes and type this code: [$-2000000]#,##0.00
4. This will give you comma seperate and 2 decimals