Excel Help Needed

Reply #7

Rakster — Mon, 14 May 2007 23:12:36 GMT

Thanks Bud

Reply #6

budward — Mon, 14 May 2007 22:49:37 GMT

=MOD(A1+5,10)

Where the A1 is just enter whatever cell you want to do lottery math on.

Reply #5

Rakster — Mon, 14 May 2007 22:32:50 GMT

Thank you so much!! I really do appreciate you taking the time to explain this... thank you!

Is there a way to do Lotto math on Excel?

Ex. 9 + 3 = 2 instead of 12

Reply #4

winsumloosesum — Mon, 14 May 2007 22:29:15 GMT

Ok

1. Select the cell, row or column of cells you want.

2. Right-Click (Mouse)

3. Select>Format Cells

4. A Format Cell Window will open

5. Click the Tab labeled Number at the top

6. In the Category Box Select>Number (Should be at the bottom)

7. In the Type Box to the right click the 0 (zero) (should be under the word General )

8. In the Box above the word General you should now see a 0 (zero)

9. Add another 0 (zero) then Click the OK button at the botto... [ More ]

Reply #3

Rakster — Mon, 14 May 2007 21:57:57 GMT

I got another question that probably is simple to answer but I can't get it...

How do you get a 0 (Zero) to remain showing when typing it into a spreadsheet? Example... 01 or 05... If I want the zero to remain on the sheet and not dissappear, how do I go about doing that?

When ever I try typing 05 or 09 into a cell it just shows the 5 or the 9... I want it to show the 0 as well.

Thanks.

Reply #2

Rakster — Sun, 13 May 2007 21:01:06 GMT

Thanks

Reply #1

LottoChica23 — Sun, 13 May 2007 01:42:39 GMT

Rakster, just pick up where we left off in this thread https://www.lotterypost.com/thread/155239.htm , after you isolate each of the three digits, just add them up e.g. +F2+F3+F4

You will get the sum of the number

Excel Help Needed

Rakster — Sun, 13 May 2007 00:51:21 GMT

I need some help with a particular issue.

I am trying to break down a sum but want the two numbers of the sum to be in seperate columns.

Example... 654 = sum of 15

I want to have the 1 in a seperate column and the 5 in a seperate column. is there a way of doing this?

Thanks