Forum Discussion
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...
- 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.
thanks for your reply
I checked.
It is in US format.
I checked.
It is in US format.
Have you check the formating of the grid?
It look to me formatting issue
Regards, Faraz Shaikh
It look to me formatting issue
Regards, Faraz Shaikh
- Which part of grid do you mean?
- Select the cell >> press ctrl + 1 >> go to customs and share the screenshot
Regards, Faraz Shaikh- I too am having the same issue. Checked format of cells changed cells and it keeps putting in the number they want and won't let me put in what I need. where do I chang the language format?
