Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I was entering timesheet data (in minutes) into an Excel spreadsheet. Then the requirements changed - the data actually needs to be in hours. Is there a way to divide all the cells by 60 in place without using formulas? Ideally, I'd like to select all the cells and somehow say "Divide by 60."

Note: I've answered my own question in the hopes that others might find it useful (or provide a better solution!).

share|improve this question

1 Answer 1

up vote 3 down vote accepted

It turns out you can do exactly what I wanted:

  1. Enter the number 60 into another cell, doesn't matter where.
  2. Copy that cell (ctrl-C).
  3. Select the cells you want to modify.
  4. Right-click, paste special.
  5. You get some options of what operation you want to apply. I picked Divide for my case.
  6. Magic! All the selected cells' values are now divided by 60. You can even delete the cell you used for the number 60.
share|improve this answer
    
Looks like that if you didn't post your question there would be no need to ask it, since you found the answer in a matter of seconds. :o) –  Mario Marinato -br- Jul 6 '11 at 21:03
2  
@Mario, yeah I was trying to follow the SE guidelines of "pretend you're on Jeopardy" when answering your own question. I had already found the solution and thought others might benefit from it. –  Kristo Jul 6 '11 at 21:51
    
Self-answering is fine on these sites. –  Lance Roberts Jul 6 '11 at 22:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.