Apr 22 2021 12:59 PM
Hello!
Could someone help me, when I'm trying to multiple a number with a decimal point with another cell, it gives me the error #value! error, but when I change the decimal point to a coma, it works just fine.
Can someone help me change it back so I can use it with decimal points instead of a coma please!!!
I use excel on the web
Apr 22 2021 01:03 PM
Excel uses the decimal separator of your Mac's system settings.
So quit Excel, make sure that the regional and language settings in MacOS are the way you want, then start Excel again.
Apr 22 2021 01:17 PM
@Hans Vogelaar Hello! Thanks for replying.
I've done that, has the same regional settings as I had before, everything was working well for almost a year, but today it decided to mess up without me changing a formar.
Apr 22 2021 01:25 PM
I am on Windows myself, I hope that someone with a Mac has a suggestion for you.
Apr 22 2021 02:46 PM
I also use windows and am not familiar with excel on the web, but my excel has an option to override the regional system settings under File/Options/Advanced. By chance, is there a similar option for you?
Apr 22 2021 03:06 PM
As far as I know, that option is not available in Excel for Mac.
Apr 22 2021 09:48 PM - edited Apr 22 2021 09:49 PM
@memo2254 This is how you get to these settings on a Mac:
Press the Apple logo in the top left hand corner of your screen
System Preferences...
Language & Region (the icon with the blue flag)
Advanced... (in the bottom right hand corner)
Here you change the grouping and decimal separators as desired.
Press OK and restart Excel.
Jun 06 2022 06:29 PM