Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In MS-Excel what is the procedure to generate automatic 14 digits random number series?

user-image
Question added by usman zahid , Accountant , KBM Chartered Certified Accountants & Registered Auditors
Date Posted: 2013/09/20
emad awad
by emad awad , internal audit manager & cost control manager , nile sugar

To generate14 digits random number use

 

=randbetween(;)

taha amer
by taha amer , Finance Manager , Arabia ‎Holding

تغيير التنسيق إلى نسق نصي Text Format بدلا من عام General أو رقم Number. أفترض طبعا أنك تعلم من أين تقوم بتنسيق الخلايا أو الجدول.

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

try this:

=RAND()*

 

Change the format of target cell from General to Number.

 

usman zahid
by usman zahid , Accountant , KBM Chartered Certified Accountants & Registered Auditors

wrong answer

More Questions Like This