It is most likely the Decimal Symbol setting that is incorrect (it should be a '.'), which is set in the Windows Control Panel | Region | Additional Settings.
Excel showing #REF or #Value instead of calculating
It is most likely the Decimal Symbol setting that is incorrect (it should be a '.'), which is set in the Windows Control Panel | Region | Additional Settings.