Pick 4 Digit Combo to VTRAC Combo

In cell A1 enter your Pick 4 Digit Combo

Example: 0012

Make sure you format the cell (Right Click cell A1> Select Format Cells > Click Custom in Category List > Enter 4 zeroes in the Type Box > Click OK

In cell B1 copy and paste this formula:

=SUMPRODUCT((MOD(MID(TEXT(A1,"0000"),ROW($1:$4),1),5)+1)*(10^(4-ROW($1:$4))))

The Pick 4 VTRAC Combo will now be in cell B1.

========================================================================

Pick 3 Digit Combo to VTRAC Combo

In cell A1 enter your Pick 3 Digit Combo

Example: 001

Makesure you format the cell (Right Click cell A1> Select Format Cells> Click Custom in Category List > Enter 3 zeroes in the Type Box> Click OK

In cell B1 copy and paste this formula:

=VALUE(CONCATENATE(MOD(VALUE(LEFT(TEXT(A1,"000"),1)),5)+1,MOD( VALUE(MID(TEXT(A1,"000"),2,1)),5)+1,MOD(VALUE(RIGHT(A1,1)),5)+1))

The Pick 3 VTRAC Combo will now be in cell B1.

Special thanks to members at MrExcel Forum for all their help!!!