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 .

1

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
2
  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
1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy