Welcome Guest
You last visited January 20, 2017, 4:53 am
All times shown are
Eastern Time (GMT-5:00)

# Excel Help Needed

Topic closed. 7 replies. Last post 10 years ago by Rakster.

 Page 1 of 1
Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: May 12, 2007, 8:51 pm - IP Logged

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

We are all Lucky... just some of us don't realize it!

United States
Member #8160
October 26, 2004
6777 Posts
Offline
 Posted: May 12, 2007, 9:42 pm - IP Logged

Rakster, just pick up where we left off in this thread http://www.lotterypost.com/thread/155239 , 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

check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

You can judge the integrity of a man by the way he treats those that can do nothing for him...

Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: May 13, 2007, 5:01 pm - IP Logged

Rakster, just pick up where we left off in this thread http://www.lotterypost.com/thread/155239 , 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

Thanks!

We are all Lucky... just some of us don't realize it!

Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: May 14, 2007, 5:57 pm - IP Logged

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.

We are all Lucky... just some of us don't realize it!

Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Online
 Posted: May 14, 2007, 6:29 pm - IP Logged

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.

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 bottom

The cell or cells will now be formatted with a leading zero such as the 05 and 09.

Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: May 14, 2007, 6:32 pm - IP Logged

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?

We are all Lucky... just some of us don't realize it!

United States
Member #33295
February 19, 2006
699 Posts
Offline
 Posted: May 14, 2007, 6:49 pm - IP Logged

=MOD(A1+5,10)

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

Isabel, you are going to feel very silly when this turns out to be make-believe.

Member #19992
August 9, 2005
2867 Posts
Offline
 Posted: May 14, 2007, 7:12 pm - IP Logged

=MOD(A1+5,10)

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

Thanks Bud!

We are all Lucky... just some of us don't realize it!

 Page 1 of 1