Automatically creating code like OTP

Closed
Deepak - Feb 15, 2022 at 04:16 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 17, 2022 at 11:51 AM
Hi Deepak,

Something like this:
=RANDBETWEEN(100000,999999)

Best regards,
Trowa
0