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

[SamuelT]

Hi,

Probably best to do this the other way round. First, select your column and format it so that the numbers are rounded to two decimal places: Format > Cells > Number > Number

Once this is done, in an empty cell type 10, then copy this. Select your column again and do: Edit > Paste Special > Divide

That should sort it.

HTH,

SamuelT