MS Excel Number format error [Solved/Closed]

- - Latest reply:  Akoh - Jan 15, 2014 at 10:59 AM

I use Ms Execl in that I have a error it like this.....

1. when I type a number 400 in the cell an give Enter. It is not showing the exact value as 400 but it shows as 0.400..

pleace sumboby clear ma error .... how to rectify it... plz
See more 

2 replies

Best answer
Thank you
Open Excel > Office button>Excel options - select Advanced and un - check the "Automatically insert a decimal point" and "OK". Now your problem may not arise.

Thank you, adi 1

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2574 users this month

Just got the same issue, Thanks for your solution!
thanks for solving
Thanks for your support
Thank you
Try this,
1.Click cell that you have problem
2.right click and select "Clear constents"

May be help you