dividing columns by 100

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to divide four columns of numbers by 100, yet I don't want any of the
cells to interact with each other. The numbers are all 100 times too big, I
just need a formula or a way to divide them all by 100 in (hopefully) one
step or equation.

Can anyone help?
 
put 100 in an unused cell.
edit|copy that cell
select your range in that column to adjust
edit|paste special|choose divide
clean up that 100 in that helper cell.
 
Put 100 in a cell, and copy that cell.

Select all the cells to divide by 100.

Goto menu Edit>PasteSpecial and in the Operation section, click the Divide
button.

Exit out.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does Excel auto-divide numerical inputs by 100? 1
Dividing a column 3
Dividing - Negative Number by Zero 5
numeric entered automatically divided 100! 1
Number automatically divided by 100, why? 4
Average of column with changing numbers of records 5
IF Function that returns a percentage 2
I don't need the actual value but what is shown 2

Back
Top