Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 4 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .