Mass Change...

  • Thread starter Thread starter Confused Man
  • Start date Start date
C

Confused Man

Hello all,

I have about 475 rows of data all input manually with no formulas. I need to
take all that data and divide it by 2. How do I go about doing that without
having to manually type in =sum(#/2)?

FWIW: I may be needing to do this with other columns later and with
different divisors. so I'd really appreciate a standard way that's easy to
change.

Any and all help greatly appreciated!
Thanks,
Confused Man
 
Hi

Enter 2 in an empty cell.
Copy that cell.
Select the cells you want changed.
Go menu Edit > PasteSpecial.
Check "Divide".
OK.

HTH. Best wishes Harald
 
2 ways of doing this:-

1) Actually changing the underlying data - Put a 2 in any blank cell that is
outside your range of data. Now copy that cell. Then select your range of
data, do Edit / Paste Special / Tick 'values' and 'divide' and then hit OK.

2) Leaving underlying values as they are - Put a 1 in any blank cell outside
your range of data, say J1. In any other blank cell outside your range of
data, put =$J$1. Now copy the cell with =$J$1 in it. Select your range of
data, do Edit / Paste Special / Tick 'formulas' and 'divide' and then hit
OK. You can now delete the cell that had =$J$1, and at th emoment all your
dat ashould appear unchanged. If you now put a 2 into cell J1 you will see
that every value in your range divides by 2. Change the value in J1 and
your data changes too.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
To add to all the other suggestions ... think about your format!

When you're done with your dividing, *all* your cells will now have the
format of "that" empty, blank cell.

You might now have to go back and format them to what you need ($, 2 - 3
decimals - no decimals, ... etc.).

SO, format "that" empty, blank cell *before* you complete the "Paste
Special", so that you'll end up with what you started with, except ... of
course ... it'll now be divided by 2.<g>
 
You guys are all awsome!!!! It works like a charm!!

Thank you all so much,
Confused Man
 
Back
Top