Here is the formula I use

Pick 4 number in Cell A1

In Cell A2 enter formula =INT(A1/1000)

In Cell B2 enter formula =INT((A1-(A2*1000))/100)

In Cell C2 enter formula =INT((A1-((A2*1000)+(B2*100)))/10)

In Cell D2 enter formula =INT((A1-((A2*1000)+(B2*100)+(C2*10)/1)))

This formula will breakdown the the Pick 4 number into 4 numbers

Hope this helps you!!.

Bud]]>

I have the following formulas for the first three digits of a pick 4 but i need to know what I am doing to get the 4th digit to transfer to its proper position.

Say I want to post the number 1234, the 1 would go in 1st postion, the 2 in the 2nd position the 3 in the 3rd and the 4 in the 4th.. I used the following to get the first three positions done but don't know how to get the 4th position placed.

First position =IF(ISBLANK(B3), ,INT(B3/100))

Sec... [ More ]]]>