MS Excel Number format error

zac - Aug 10, 2009 at 01:00 AM
 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

2 replies

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.
Just got the same issue, Thanks for your solution!
thanks for solving
Thanks for your support
Try this,
1.Click cell that you have problem
2.right click and select "Clear constents"

May be help you