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 http://www.random.org/)

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….