Excel '07

By clarkd038 ·
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

There is a function

by tintoman In reply to Excel '07

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

Related Discussions

Related Forums