In A1, put in 0
in A2 put in 1
select A1:A2 and do format=Cells=Number Tab, select custom and put in 000

now select A1:A2 and drag fill down to row 999

if you want text values: then after doing the above

in B1 put in

=Text(A1,"000")
then drag fill down to row 999
Select column B and do Edit=Copy, then Edit=Paste special and select
Values.

then you can delete column A.


--
Regards,
Tom Ogilvy

"Rashid Khan" wrote in message
...
Hello All,
I am using Office XP and searched the NG but could not find a suitable
post.
I wish to have a macro which would generate all the possible comibination
between 000 and 999.
eg.
000
001
010
100
..
111
101
110
011
...
I hope I am clear
Can this be achieved.
TIA
Rashid