Maybe copy n paste special multiply ?
Copy A2. Select the range A1:D1, right-click paste special check
multiply ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lion2004" wrote:
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