Put =A1*C$1 in B1 and fill it down.

--
Jim
"MS" wrote in message
...
|I have a column A1:A10 with numbers in it. I also have a cell C1 with a
| number 5. I wish to create a column B1:B10 that will be as follow:
| B1 = A1*C1
| B2 = A2*C1
| B3 = A3*C1 and so on.
|
| I do not want to use C1, C2, C3... in my formula. Is this possible?
|
| Thanks
| MS