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 1000).
even when I change the cell's format, it doesn't work and excel changes the number again.
for example, while I enter "1.222", excel changes it to "1222".
I would appreciate your help.
- 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.
7 Replies
- Please check your system's local setting, it might be in the UK format.
Regards, Faraz Shaikh- thanks for your reply
I checked.
It is in US format.- Have you check the formating of the grid?
It look to me formatting issue
Regards, Faraz Shaikh
