View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Division of all cells by a common number

Hi,

Put the number 25 in a cell and copy it. Select the range of numbers and then

Edit|Paste special - select 'divide'
OK


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Icegirl" wrote:

Hi,
I have the following data:

Series A
124
34
946
576

I would like to divide each cell in the above column by 25, and have the
number returned in the same cell without doing so indvidually. How do I
manage that?