Random Intergers

[gregfetzer]

Hello everyone,

I need to create an 8 digit random integer with Char (84) leading. Can anyone assist me with the formula? I have manual calculation turned off..


Thanks!!

[Ace_XL]

Try..

=RANDBETWEEN(84000000,84999999)

[gregfetzer]

Thanks - I should have known that - do you know how to write the function to add character 84 which is the letter "T" in front of these numbers?

[Ace_XL]

to add character 84 which is the letter "T" in front of these numbers?

please elaborate..perhaps an example?

[gregfetzer]

Each random integer should have the letter T in front of the numbers. i.e. T84934675 Just wondering if there is a way to write it in the formula? Thanks

[gregfetzer]

Thank you Chemist B --- I appreciate it

[ChemistB]

=CHAR(84)&RANDBETWEEN(10000000,99999999) or just "T"&RANDBETWEEN(10000000, 99999999)