Forum Discussion

memo2254's avatar
memo2254
Copper Contributor
Apr 22, 2021

#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 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 

Excel for web
Excel on Mac
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 22, 2021

    memo2254 

    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.

    • memo2254's avatar
      memo2254
      Copper Contributor
      Apr 22, 2021

      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.

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Apr 23, 2021

        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.

         

Resources