Azid Rush Donating doesnt allow you to be an idiot! Member 692 Member For: 17y 8m Gender: Male Location: Newcastle Posted 27/04/09 05:55 AM Share Posted 27/04/09 05:55 AM (edited) hey guysnot a gaming question but didnt know where else to post a pc question so here it is.Im just doing up a spreadsheet with microsoft excel. Ive put in a random number formula " =RANDBETWEEN(5, 108)" which works fine but unfortunately its working too well, apparently with this formula it redoes it with new random numbers everytime something in the spreadsheet is done eg. new data added etcmy problem is that I have to add data to another column based on the random number next to it, and everytime I add the data the random number changes making the data useless loldoes anyone know how to stop the column randomising after it does it once?cheers Edited 27/04/09 06:01 AM by Azid Rush Link to comment Share on other sites More sharing options...
wiresquire Member 266 Member For: 19y 10m 22d Posted 27/04/09 06:19 AM Share Posted 27/04/09 06:19 AM Once you've generated the random numbers once, copy and then Paste Special.There should be a checkbox or something for "Values".This then converts the formula to a value - like something you typed in.Then save it, and when you open/recalculate, the values won't change anymore.hthqs Link to comment Share on other sites More sharing options...
Azid Rush Donating doesnt allow you to be an idiot! Member 692 Member For: 17y 8m Gender: Male Location: Newcastle Posted 27/04/09 07:03 AM Author Share Posted 27/04/09 07:03 AM sorry mate what do u mean copy and then paste special? Link to comment Share on other sites More sharing options...
Azid Rush Donating doesnt allow you to be an idiot! Member 692 Member For: 17y 8m Gender: Male Location: Newcastle Posted 27/04/09 07:05 AM Author Share Posted 27/04/09 07:05 AM oh can that questionit worked cheers mate saved me some trouble Link to comment Share on other sites More sharing options...
smicky Go Pies!!! Donating Members 2,852 Member For: 16y 8m 1d Gender: Male Location: Vic Somewhere - Sometimes NSW Posted 09/06/09 10:58 AM Share Posted 09/06/09 10:58 AM hehehe, there is a few IT nerds on here... Link to comment Share on other sites More sharing options...
wiresquire Member 266 Member For: 19y 10m 22d Posted 09/06/09 12:00 PM Share Posted 09/06/09 12:00 PM lolHappy to help you out any time you need. I'll even do mates rates of $400/hour, minimum of 8 hours ws Link to comment Share on other sites More sharing options...
smicky Go Pies!!! Donating Members 2,852 Member For: 16y 8m 1d Gender: Male Location: Vic Somewhere - Sometimes NSW Posted 09/06/09 12:19 PM Share Posted 09/06/09 12:19 PM Dude, your more expensive then we are!your a RIP! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now