MS Excel Number format errorSolved/Closed

Question

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

Guy · Answer

Try this,
1.Click cell that you have problem
2.right click and select "Clear constents"

May be help you

adi · Answer

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.

MS Excel Number format error

2 replies

Subscribe To Our Newsletter!