paste special

[osaka78]

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

[Dav]

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