Forum Discussion

Shokoufeh's avatar
Shokoufeh
Copper Contributor
Jul 31, 2022
Solved

Excel changes numbers automatically

Hi every one I've faced something strange. please help me on that. while I enter a number which has three or more numbers after decimal, excel removes decimal automatically (multiplies number to 10...
excel
Formulas and Functions
  • Shokoufeh's avatar
    Shokoufeh
    Jul 31, 2022
    My problem is solved.
    I added UK format language and it worked. My problem disappeared 🙂

    And what is interesting is that while I removed UK format language, my problem didn't come back again.
    However, thank you very much for your help.
ExcelExciting's avatar
ExcelExciting
MVP
Jul 31, 2022
Please check your system's local setting, it might be in the UK format.
Regards, Faraz Shaikh
  • Shokoufeh's avatar
    Shokoufeh
    Copper Contributor
    Jul 31, 2022
    thanks for your reply
    I checked.
    It is in US format.
    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Jul 31, 2022
      Have you check the formating of the grid?
      It look to me formatting issue

      Regards, Faraz Shaikh
      • Shokoufeh's avatar
        Shokoufeh
        Copper Contributor
        Jul 31, 2022
        Which part of grid do you mean?