Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Anyone know of a quick way of doing this? I want to populate a whole bunch of cells with random numbers between say 1000 and 20000 and have the numbers formatted as currency.
Help appreciated - kudos points for knowledge available.
=RANDBETWEEN(1000, 20000)
EDIT: and just format the cells as currently.
dunno about a fully automatic process but I thought excel had a random no generator built in
(or else something like this definitely could do what you want [url= http://www.random.org/ ]http://www.random.org/[/url])
as long as the cells are in a single column or contiguous, shouldn't be hard to set as currency
what Jesus said
or if you want non-integers then
= 1000 + RAND()*19000
If you don't want them dynamic then just copy them all and paste as values
The random number generator in excel is not very 'random' if you need it for something that actually requires random numbers (e.g. monte carlo function).
Better off getting a Geiger counter and using background radiation to get true randomness.*
*Better, but possibly not easier....