Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
A question about random numbers in Excel?
I'm using Excel 2007 and have created a modeling program that uses a lot of random numbers generated by RANDBETWEEN. Every time I open the file, or do a calculation, all the random numbers are re-generated. That's fine in some cases, but I'd also like to know if I can "freeze" the results at some point and save it, and if I open the file again I have the same results showing.
I'm dating myself here, but in Lotus-123 you could turn off the calculations, which would achieve the result I'm looking for if there was an equivalent command in Excel.
Any help? Thanks...!
2 Answers
- expletive_xomLv 71 decade agoFavorite Answer
you can change excel to Manual Calculation (F9) too
- click on the Office Button (top left logo)
- click excel options
- Click formulas
- change it to Manual
- looks like you want to uncheck recalculate before saving
then just hit the F9 key and it will recalculate
- Anonymous4 years ago
Use the randbetween function and divide by potential of one hundred with the aid of fact the randbetween function generates random numbers between integers and dividing by potential of one hundred will shrink the numbers to decimal =randbetween(4,24)/one hundred positioned the above in a cellular and then pick the decrease appropriate nook of the cellular and whilst conserving the ctrl key drag till you have crammed 30 cells.
