Forum Discussion
Shokoufeh
Aug 01, 2022Copper Contributor
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...
- Aug 01, 2022My 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.
Aug 01, 2022
Please check your system's local setting, it might be in the UK format.
Regards, Faraz Shaikh
Regards, Faraz Shaikh
Shokoufeh
Aug 01, 2022Copper Contributor
thanks for your reply
I checked.
It is in US format.
I checked.
It is in US format.
- Aug 01, 2022Have you check the formating of the grid?
It look to me formatting issue
Regards, Faraz Shaikh- ShokoufehAug 01, 2022Copper ContributorWhich part of grid do you mean?
- Aug 01, 2022Select the cell >> press ctrl + 1 >> go to customs and share the screenshot
Regards, Faraz Shaikh