I am having a problem with a Pick 3 analysis that I am trying to run.

I am trying to set up a skip table of all the Pick 3 possible Vtrac Boxed combos (35 of them).

I have set up the spreadsheet with drawn numbers in Column D and all possibles in row 1, starting a column E.

I am using the formula

=IF($D6=E$1,0,E5+1)

The problem that I am having is that the formula doesn't recognize the numbers in column D. These were originally in 3 seperate columns, so I used CONCATENATE to combine them and then copy, paste values to convert the formula to numbers. They are formatted as number, special 000, to show leading zeros.

If I

**type**the number into the cells in column D the formula works perfectly, so I am thinking it is a format issue. But, I don't want to type all 650 numbers over -- think of the possibility of error!

Can someone help?