Excel gives error whenever I paste a code with “,”

microsoft excel

My excel is refusing every code that I paste that has "," (comma) (like to separate arguments). What could be the cause, could it be because my PC region is Brazil and excel is in english? It seems to be a system error problem, like it not recognizing the "," as a separator for arguments, something like that. It says like the formula is wrong, but it's not wrong cause others have tried flawlessly, and it always point to something with a ","

Best Answer

This is probably because of your regional settings. Setting the region to Portuguese (Brazil) on English Windows changes many things, in particular:

  • The decimal separator is ,
  • The list separator is ; (this is a comma when using US English settings)

So the arguments should be separated by a semi-colon.