Random numbers add pointless decimals at end of whole number

[Livin404]

Good day,

I have a formula

=RAND()*(1999999999-1000000001)+ 1000000001

which gives me a random 10 digit number beginning with 1. However if I copy the number and paste over to another cell end up getting the number but with a decimal.

For example a number such as 1489498658 I end up getting 1489498658.42415. I tried changing formats to numbers with 0 Decimals.

Any assistance would be greatly appreciated.

 

[shinigamilight]

Because it is generating a number with a decimal digit in the first place. Change the formatting of the cell with the formula to number and bump up the decimals. You can enclose the whole formula in an int function if you want integer.

 

[Livin404]

Because it is generating a number with a decimal digit in the first place. Change the formatting of the cell with the formula to number and bump up the decimals. You can enclose the whole formula in an int function if you want integer.
View attachment 108096

I did try changing the format to a number with 0 decimals and I'm still getting a number followed by a dot and four numbers.

 

[Eric W]

Or use

=RANDBETWEEN(1000000000,9999999999)

If you want to stick with RND() you need to use

=INT(RND()*(1999999999-1000000001)+1000000001)

like Livin404 said, because RND() creates numbers with more than 10 decimals places.

 

[Livin404]

Or use

=RANDBETWEEN(1000000000,9999999999)

If you want to stick with RND() you need to use

=INT(RND()*(1999999999-1000000001)+1000000001)

like Livin404 said, because RND() creates numbers with more than 10 decimals places.

Thank you I used the INT version. The only thing I changed was I used Rand rather than Rnd.