Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using Excel 2004 for Mac Version 11.2 on Mac OS X 10.4 (Tiger) right now.

I cannot for the life of me figure out why it insists on using commas to represent decimal places. Does anyone know how to change this to periods?

share|improve this question
1  
Sounds to me like a localization problem. I.e. in Europe, a dot is used, in american language setting a comma. Not sure how to change it though.. – socken23 Nov 4 '10 at 11:23
up vote 7 down vote accepted

Go to:

System Preferences -> International -> Input Menu

Check off

Show input menu in menu bar

Look up in the menu bar, and make sure the country selected is correct for you ( Assuming US ). If it's set for a different country, you may see this issue. I believe if your input is set to German, for example, it will exhibit what you describe seeing in Excel.

EDIT: details on solution from @sixtyfootersdude:

This is what my international panel looks like. You can see that there is a little warning there. Here is what resolved the problem:

I changed the Region to US I closed the panel I opened excel (everything is now using periods) I quit excel I reopened the international panel I changed the region back to Canada Apparently this solves the problem.

alt text

share|improve this answer
    
Cool, thanks for the help. Your answer helped me to figure out how to solve this. If you copy and paste my answer into yours I will accept your answer. – sixtyfootersdude Nov 4 '10 at 12:16

In Mac OS X 10.10 (Yosemite): System preferences -> Language and Region -> Region: United Kingdom (or another country that uses dots to represent decimal places).

share|improve this answer

This is what my international panel looks like. You can see that there is a little warning there. Here is what resolved the problem:

  1. I changed the Region to US
  2. I closed the panel
  3. I opened excel (everything is now using periods)
  4. I quit excel
  5. I reopened the international panel
  6. I changed the region back to Canada

Apparently this solves the problem.

alt text

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .