Dear Friends
Suppose if I have different values in cell A1:A100 and I want to divide all
of them by 10 and get the result rounded to 2 decimal place . how can I do
that by using paste special commend
regards
Dear Friends
Suppose if I have different values in cell A1:A100 and I want to divide all
of them by 10 and get the result rounded to 2 decimal place . how can I do
that by using paste special commend
regards
type 10 in a cell select it the copy paste special choose divide and paste over the range a1:a100, then just format the range to 2 d.p
Regards
Dav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks