The period instead of the comma
Solved/Closed
france
-
Thierry -
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.
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 réponses
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.
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.
more than 10 years later, your answer still helped me :)