range * constant
Hi
- put 10 in an empty cell
- copy this cell
- select your numbers
- goto 'Edit - Paste Special' and choose the action 'Multiply' (or
'Divide')
--
Regards
Frank Kabel
Frankfurt, Germany
"linty" schrieb im Newsbeitrag
om...
Can one of you Excel experts tell me how to reduce all cells in a
data
array by a factor of 10 (how to multiply all cells in a range by a
constant)?
|