Hi!

If you're using the RANDBETWEEN function it only returns integers (whole
numbers).

You could try this:

=RANDBETWEEN(55,105)/10

Biff

"ddawg09" wrote in
message ...

What if you only want random numbers within a given range. I need 100
numbers between 5.5 and 10.5 but I did the Randombetween function and
dragged it down but all it did was pretty much copy.


--
ddawg09
------------------------------------------------------------------------
ddawg09's Profile:
http://www.excelforum.com/member.php...o&userid=31205
View this thread: http://www.excelforum.com/showthread...hreadid=521543