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

MVP

Jul 31, 2022

Please check your system's local setting, it might be in the UK format.
Regards, Faraz Shaikh

Shokoufeh

Copper Contributor

Jul 31, 2022

thanks for your reply
I checked.
It is in US format.

ExcelExciting
MVP
Jul 31, 2022
Have you check the formating of the grid?
It look to me formatting issue

Regards, Faraz Shaikh
- Shokoufeh
  Copper Contributor
  Jul 31, 2022
  Which part of grid do you mean?
  - ExcelExciting
    MVP
    Jul 31, 2022
    Select the cell >> press ctrl + 1 >> go to customs and share the screenshot
    Regards, Faraz Shaikh

Forum Discussion

Excel changes numbers automatically