applying rounding formula to entire worksheet
After posting my last reply I found the Tools Options feature.
Your method still doesn't work for the task at hand: turning $432 into $429,
$5676 into $5679 etc. If you know how using that simple method, do tell us
please. Thanks.
"Lori" wrote:
I was not clear, use tools options and check the precision as
displayed box on the calculation tab you will get a message saying data
will lose accuracy then click OK. You can try this out in a new
workbook and then paste back without formatting.
mateo wrote:
hi, thanks.
first, you must be using a different version of excel than me because "tools
calculation" doesn't exist on my excel 2003. If I highlight on a cell then
right click, I can choose Format cells. When I go to custom and add "#,.00"
all it does is output a value with two decimal places. -- not round to the
nearest 10. please advise.
"Lori" wrote:
To round all numbers to nearest 10:
Select tools calculation Precision as displayed then format cells
number custom "#,.00".
(Switch ",." to ".," for European settings). It's probably best to copy
data to a new workbook first and then paste back as formulas only.
To subtract 1 from cells:
Enter 1 in a cell copy, edit goto special constants numbers and
Edit paste Special Values and Subtract.
mateo wrote:
Hi, I have worksheet full of prices that I want to round to the nearest
multiple of 10 then subtract 1 to get a nice price with 9 on the end. (having
already multiplied the original numbers by a percent to change currencies)
I know how to make $47 into $49 by using =mround(47,10)-1 but how do I
apply it to the whole sheet? Paste special Formulas is not working for me...
Thanks
|