Forum Discussion

Sarmad15's avatar
Sarmad15
Copper Contributor
Jun 10, 2020

issue with comma

Hi

 

I have an issue when I open an excel sheet from MS Teams ( Online ) then the excel can not calculate the numbers with comma but it works with dot "." . any explanation, please?

 

Best regards

Sarmad Nazar

Excel for web

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 10, 2020

    Sarmad15 

    You need to change regional settings for the Sharepoint site connected to Teams. Or change regional settings on your PC.

    • Sarmad15's avatar
      Sarmad15
      Copper Contributor
      Jun 10, 2020

      SergeiBaklan 

       

      Hi Sergei

       

      I have changed the regional setting on that site on SharePoint from Danish to USA but the excel still does not accept comma .. which regional setting I need to change to please?

       

      See my attachment please 

       

      Best regards

      Sarmad Nazar

Resources