Two questions from a rank amateur
Posted by Doug on February 12, 2002 8:02 AM
I seldom if ever use Excel, so please excuse my ignorance...
1. How do I get a cell to drop all numbers after the
tenth spot without rounding up or down, i.e,get
14.76 to show as 14.7?
2. How do I get a formula to stay focused on data in
a particular cell, basically awaiting new data, vs.
referring to the data in the cell once it's
moved? If I cut and paste cell data to a new
location, I want the formula that refers to the
original cell location to calculate new data to be
I hope I've made some semblence of sense here...Thanks