Need Excel Help with Vtracs

Reply #4

Sage — Sun, 21 Nov 2010 21:27:36 GMT

Thank you so much! It worked like a charm! Your the best LottoChica23. Many blessing to you and yours! Have a wonderful weekend

Reply #3

LottoChica23 — Sun, 21 Nov 2010 16:48:57 GMT

You're quite welcome.

I'm doing well.

Enjoy the holidays

Reply #2

Sage — Sun, 21 Nov 2010 16:34:23 GMT

Wow that was so fast Thank you so much! you guys and Gals are the best! How have you been Lottochica23

Reply #1

LottoChica23 — Sun, 21 Nov 2010 16:26:30 GMT

Try this:

For 3 Digit numbers

=MOD(INT(P3/100),5)*100+MOD(INT(P3/10),5)*10+MOD(P3,5)+111

Change the P3 in the formula to the cell that your 3 digit number is in

For Single Digits

=MOD(P3,5)+1

Chang the P3 to the respective cells that your single digits are in

Need Excel Help with Vtracs

Sage — Sun, 21 Nov 2010 16:10:26 GMT

I need a formula to convert a regular digit to a vtrac.

Can anyone help me? Thanks.