View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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)?