Yours R

...solution by just typing in the 5 digit numb? Hi... I would like to come out with a formula in Microsoft Office Excel 2007. E.g 12345, there are 5 digit number which can be relocate at different position and the possibility to get the total 5 digit number is/with 120 different numbers. If I want to write it manually, it is going to take my time. How can I make it in any Microsoft Office 2007, to come out with a solution by just typing in the 5 digit number and obtaining the total 120 number in moments?

Ajax

Use Randbetween function

=Randbetween(10000,99999)

Copy and paste it int 120 cells and now you can have 120 numbers.

If you want to change the numers Just Press F9 and see all the numbers will be changed automatically.

Don't forget to Copy and Paste Special to the Values.

(*.*)