=MOD(INT((ROW(A1)-1)/125),5)&MOD(INT((ROW(A1)-1)/25),5)&MOD(INT((ROW(A1)-1)/5),5)&MOD(ROW(A1)-1,5)
and copy down your 625 rows.
--
David Biddulph

"Kate" wrote in message
...
Yes, 0000 would be a valid combination.

"Mike H" wrote:

Kate,

Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you
give
an examples of 0001 which uses the zero 3 times. Do you really mean this?
If
so is 0000 a valid combination and if not why not? what are the rules?

Mike

"Kate" wrote:

I have the following numbers: 0, 1, 2, 3, 4

Looking for a formula that lists all possible four digit combinations
for
the above five digits.

i.e.
0001
0002

Thank you.