View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James8309 James8309 is offline
external usenet poster
 
Posts: 105
Default Autofill Question

Hi everyone,

I am having alot of difficulties trying to solve this problem.

Basically I am coding something in column A like this;

1. 11XXX (X being any number from 0 to 9 i.e.11001 till 11999)

2. X11XX (X being any number from 0 to 9 ) = this part I have a
problem. How do I fill in every possible combination that has 1 in 2nd
and 3rd spot? e.g. 311411, 211423 .. etc etc

Please help (T_T)


thank you for your help in advance

regards,


James