| View previous topic :: View next topic |
| Author |
Message |
Tribal_Gecko
General User
Joined: 16 Feb 2005
Posts: 7
|
 Posted: Thu Sep 28, 2006 5:56 pm Post subject: Copy cells but NOT formulas |
 |
|
Hopefully this is an easyone to answer.
How do I copy a cells contents, but not the formula.
For example I have a cell and am using the RAND function to spit out a number 1-45. I need to then copy those numbers (there are 75+ of them) onto the sheet further down. But I don't want the RAND function / formula, just the cell contents / numbers. Copy / Paste does the whole formula. |
|
| Back to top |
|
 |
Tribal_Gecko
General User
Joined: 16 Feb 2005
Posts: 7
|
| Posted: Thu Sep 28, 2006 6:02 pm Post subject: |
|
|
| Nevermind, I got it, sorry :-/ |
|
| Back to top |
|
|
|
