The period instead of the comma

Solved/Closed
france -  
 Thierry -
Hello,
my problem is as follows: in Excel, when I enter numbers using the numeric keypad on my keyboard, I can't directly input a period; a comma appears instead. What solution is there for this?
If someone could help me, that would be nice. Thanks in advance.
Configuration: Windows XP Internet Explorer 6.0

8 answers

  1. zzz383 Posted messages 12 Status Member 18
     
    Hello,

    It's not happening in Excel but in Windows: Start -> Control Panel -> Regional and Language Options (icon: globe) in the "Regional Options" tab click the "Customize" button: you replace the decimal separator with a point (on the alpha keyboard) or whatever else you want. Don't forget to also change the digit grouping symbol (it might be the point too!) and put a (yes, yes, in typography we say a space) space.

    Note that the standards (both Belgian and French) are: the comma as a decimal separator and the space for thousands. But of course, everyone does as they please.
    115
    1. zzz
       
      Thank you!
      0
    2. Lisa
       
      Thank you very much,
      more than 10 years later, your answer still helped me :)
      1
    3. Thierry
       
      I am an older person, not at all comfortable with "tutorials", I understood your explanation completely and I am still quite surprised to have solved a "problem" that has been poisoning my life for years so quickly. THANK YOU!
      0