Forum Discussion
#value! error
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 wo...
HansVogelaar 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.
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.
- This worked perfectly for me on my Macbook. Thanks so much Riny!
