Software

Ask something
Question Locked

Excel '07

0 helpful
2 replies

by clarkd038

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by tintoman

In Excel 2007 there is a function to "round down" or "round up" numbers when decimal points are not appropriate, it sounds like somewhere in your sheet there is a formula to do this.
Try adding a decimal place to see if it helps, or perhaps copy the data to a new sheet

This discussion is closed to new replies.