Multiply a co;omn by a constant

[Q]

It appears Excel is very powerful at performing funtions on arrays, however,
I simply want to multiply a whole column of numbers by one constant number,
and get the result either in the same column (for each individual number), or
the next column. It appears that excel does not have this capability. Is
there a program that does?

 

[Stan Brown]

It appears Excel is very powerful at performing funtions on arrays, however,
I simply want to multiply a whole column of numbers by one constant number,
and get the result either in the same column (for each individual number), or
the next column. It appears that excel does not have this capability. Is
there a program that does?

Yes, and it's called Excel. Use Edit | Paste Special, and specify
"Values" and "Multiply.

 

[T. Valko]

See this...

http://contextures.com/xlDataEntry04.html