Random number Generator gives decimals after the minimal number of digits.

[Livin404]

Greetings, I have a formula I use

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

which gives me a random 10 digit number always beginning with 1. I've set the format to 0 decimals and numbers. Unfortunately I get decimals for example 1946194471.75967. I only want to be left with the first 10 digits. I thought it may have been a leading apostrophe which isn't the case. Any suggestions. The number of decimals after the number can vary. I hope someone may have a bit of advice.
Thank you,

 

[MrTomasz]

not sure why it shows declimals for you, it does not show them in my excel, anyway you can try this:

=LEFT(RAND()*(1999999999-1000000001)+1000000001;10)

 

[Livin404]

not sure why it shows declimals for you, it does not show them in my excel, anyway you can try this:

=LEFT(RAND()*(1999999999-1000000001)+1000000001;10)

I tried your code and I think it is missing a "(" somewhere in there.

 

[MrTomasz]

maybe your excel use "," instead ";"

Otherwise try to find left function in your excel and play with it. You define word and how many characters it should take (begining from the start of text)

 

[Livin404]

maybe your excel use "," instead ";"

Otherwise try to find left function in your excel and play with it. You define word and how many characters it should take (begining from the start of text)

Thank you, that worked!