View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default change values globally

Try this:

Put 1.1 (or 110%) in an empty cell
EditCopy
Select the cells you want impacted
EditPaste Special
-Multiply
-Values
Click [OK]

(If you make a mistake...EditUndo)

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"MIke" wrote:

I have a price book that i made in excel 97. I want to raise the values of
the cells by 10 % with out having to do each cell independently. I would like
to select all the cells that need to be change and do it globally. Can any
one help