MS Excel Number format error [Solved/Closed]

Report
-
 Akoh -
Hello,

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.
1
Thank you

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

CCM 2942 users have said thank you to us this month

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