Decimal separation by a point instead of a comma
Solved
392nathalie
Posted messages
2
Registration date
Status
Member
Last intervention
-
Rgis -
Rgis -
Hello,
Since the update of my Mac - version MacOS High Sierra 10.13.1, I can no longer change the decimal separator. I am using a bluetooth numeric keypad with the dot for separation and now calculations do not work if I use a dot, but only if I use a comma, which is not very practical when doing accounting.
I tried to change this in system preferences - language and region, etc... I put "." instead of "," - I also restarted Excel, but nothing works.
Who could help me? Thank you in advance.
Since the update of my Mac - version MacOS High Sierra 10.13.1, I can no longer change the decimal separator. I am using a bluetooth numeric keypad with the dot for separation and now calculations do not work if I use a dot, but only if I use a comma, which is not very practical when doing accounting.
I tried to change this in system preferences - language and region, etc... I put "." instead of "," - I also restarted Excel, but nothing works.
Who could help me? Thank you in advance.
3 answers
-
Indeed, if it is indeed Excel, the decimal separator taken into account is the one selected in the "Language and Region" preferences panel. You need to restart Excel for any changes to take effect. If that doesn't work for you, the cause is probably elsewhere? In some cases, it is necessary to restart the Mac for preference changes to take effect. Have you tried?
What version of Excel is affected, and what is its update level? In other software, is the point taken as the decimal separator?
Also, check the settings and configurations related to your numeric keypad (what model?) and whether it requires a specific driver with High Sierra. With the numeric keypad of my Apple keyboard, the "point" on the numeric keypad is considered as "comma" (the decimal separator according to the French standard of France) and displayed as such in Excel (and even in Word or TextEdit)...
Hello at your place!
Bernard -
Thank you, indeed simply quitting Excel was not enough. Restarting my Mac completely fixed the issue.
Great! I can get back to work now :) -
I have the same problem since the "High Sierra" update, but with "numbers" instead of "excel". Restarting the Mac did not solve the problem.
