Excel ’07

When I am entering data into excel ’07 it keeps on dropping the last number and turning it into a 0, i have formatted the cells so that they are number and have no decimal point, I am lost as to why this is happening.

thanks