Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

up vote 5 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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.