Thank you David Biddulph!
It was exacly what i needed.

Kind regards,

Peter

"David Biddulph" wrote:

By formula:
=A1*$A2 and copy across the 4 columns.

Alternatively, if you want to change the existing values in row 1, select
A2, copy, select A1 to D1, Edit/ Paste Special/ Multiply.
--
David Biddulph

"Lion2004" wrote in message
...
I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter