hey guys

not 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 etc

my 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 lol

does anyone know how to stop the column randomising after it does it once?

cheers

Edited April 27, 200917 yr by Azid Rush

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.

hth

qs

sorry mate what do u mean copy and then paste special?

oh can that question

it worked cheers mate saved me some trouble

hehehe, there is a few IT nerds on here...

lol

Happy to help you out any time you need. I'll even do mates rates of $400/hour, minimum of 8 hours

ws

Dude, your more expensive then we are!

your a RIP!