Automatically creating code like OTP

Deepak - Feb 15, 2022 at 04:16 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Feb 17, 2022 at 11:51 AM
Hello,
I want to make some automatically code or number against once I enter data in cell. I mean it's like OTP number . It's not necessary that it's come serialwise. Any code


System Configuration: Android / Chrome 97.0.4692.98

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Feb 17, 2022 at 11:51 AM
Hi Deepak,

Something like this:
=RANDBETWEEN(100000,999999)

Best regards,
Trowa
0