/blogentry/29548 winsumloosesum's Blog: 3 Digit and 4 Digit Excel Formulas en-us Lottery Post RSS Generator /blogentry/29548#c47656 /blogentry/29548#c47656 Tue, 13 Apr 2010 05:36:56 GMT gopher07 please send me this program for ohio

]]> gopher07 /blogentry/29548#c36575 /blogentry/29548#c36575 Tue, 05 May 2009 16:00:57 GMT dimps520 please send me this program for pa.

]]> dimps520 /blogentry/29548 /blogentry/29548 Tue, 05 May 2009 04:44:37 GMT winsumloosesum Creating Boxed Numbers from inividual cells:

Pick 3 - Digit 1 = Cell A1

Digit 2 = Cell B1

Digit 3 = Cell C1

Formula in Cell D1 - =VALUE(SMALL(A1:C1,1) SMALL(A1:C1,2) SMALL(A1:C1,3))

Format Cell D1 Right Click Cell D1 Format Cells Number Tab Custom enter 3 zeroes (000) in Type Box Click OK

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

Creating Boxed Numbers from inividual cells:

Pick 4 - Digit 1 = Cell A1

Digit 2 = Cell B1

Digit 3 = Cell C1

Digit 4 = Cell D1

Formula in Cell E1 - =VALUE(SMALL(A2:D2,1) SMALL(A2:D2,2) SMALL(A2:D2,3) SMALL(A2:D2,4))

Format Cell E1 Right Click Cell E1 Format Cells Number Tab Custom enter 4 zeroes (0000) in Type Box click OK

... [ More ]

]]> Blog Entry winsumloosesum https://www.lotterypost.com/blogentry/29548