|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 17th, 2009, 04:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apply Global Formula
I want to take a range of numbers in separate cells and divide them all by 2
and have the results replace the numbers listed. Is this possible in Excel? 
|
|
#2
April 17th, 2009, 04:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Apply Global Formula
Donna K.;312150 Wrote: I want to take a range of numbers in separate cells and divide them all by 2 and have the results replace the numbers listed. Is this possible in Excel? Hi, enter 2 in an empty cell - Copy this cell Select the cells you want to divide ( holding down shift or Ctrl key if needed Right-Click/Paste Special/Under "Operations" check " divide" / OK -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87290
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
