Welcome Guest
Log In | Register )
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
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
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!

    LottoChica23's avatar - Aquarius
    Fughedaboutit (NY)
    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 

     

    Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

    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...Thumbs Up

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      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!

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        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!

          winsumloosesum's avatar - Lottery-060.jpg
          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. 

            Rakster's avatar - praying hands.jpg
            Saskatchewan
            Canada
            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!

              Avatar

              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.

              Smile

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

                Rakster's avatar - praying hands.jpg
                Saskatchewan
                Canada
                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.

                Smile

                Thanks Bud!

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