Welcome Guest
Log In | Register )
You last visited January 21, 2017, 12:28 pm
All times shown are
Eastern Time (GMT-5:00)

Using excel and cut and paste on Lottery Post

Topic closed. 13 replies. Last post 6 years ago by petinuk.

Page 1 of 1
PrintE-mailLink
jackpotismine's avatar - kanji for_peace.jpg
Kunming
China
Member #57910
January 23, 2008
3626 Posts
Offline
Posted: December 30, 2010, 1:45 am - IP Logged

I'm confused. Everytime I try to cut and paste an excel portion of a sheet to lotterypost, it comes out nothing like what's on my excel program. Here is an example of what I mean:              These numbers should be shown vertical. What am I doing wrong? I seen other posters post there excel sheets and it look normal. Any help would be appreciated.  I'm using excel 2002 SP3.  Can I capture screen and paste on here?

8 6 9 8 0 4 5 3 7 0 8 5 2 9 5 2 4 5 1 9 4 6 3 8 0 9 7 4 6 9 
T

 


Play to win!

    Avatar
    Florida
    United States
    Member #66575
    October 30, 2008
    3549 Posts
    Offline
    Posted: December 30, 2010, 1:55 am - IP Logged

    I'm confused. Everytime I try to cut and paste an excel portion of a sheet to lotterypost, it comes out nothing like what's on my excel program. Here is an example of what I mean:              These numbers should be shown vertical. What am I doing wrong? I seen other posters post there excel sheets and it look normal. Any help would be appreciated.  I'm using excel 2002 SP3.  Can I capture screen and paste on here?

    8 6 9 8 0 4 5 3 7 0 8 5 2 9 5 2 4 5 1 9 4 6 3 8 0 9 7 4 6 9 
    T

     


    Might try using "Paste From Word"

     

    903903OEEHLL123
    021021EEOLLL033
    499499EOOLHH224
    477477EOOLHH189
    422422EEELLL088
    793793OOOHHL191
    498498EOELHH213
    462462EEELHL123
    578578OOEHHH202
    262262EEELHL101

     

    CarliG

      jackpotismine's avatar - kanji for_peace.jpg
      Kunming
      China
      Member #57910
      January 23, 2008
      3626 Posts
      Offline
      Posted: December 30, 2010, 2:00 am - IP Logged

      0

      3

      1

      11

      1

      13

      15

      19

      2

      4

      11

      16

      3

      16

      1

      5

      4

      1

      5

      1

      5

      1

      38

      3

      6

      7

       

      14

      7

      12

      26

      2

      8

       

      3

      7

      9

      15

      3

       



      0

      3

      1

      11

      1

      13

      15

      19

      2

      4

      11

      16

      3

      16

      1

      5

      4

      1

      5

      1

      5

      1

      38

      3

      6

      7

       

      14

      7

      12

      26

      2

      8

       

      3

      7

      9

      15

      3

       

      Play to win!

        jackpotismine's avatar - kanji for_peace.jpg
        Kunming
        China
        Member #57910
        January 23, 2008
        3626 Posts
        Offline
        Posted: December 30, 2010, 2:05 am - IP Logged

        0

        3

        1

        11

        1

        13

        15

        19

        2

        4

        11

        16

        3

        16

        1

        5

        4

        1

        5

        1

        5

        1

        38

        3

        6

        7

         

        14

        7

        12

        26

        2

        8

         

        3

        7

        9

        15

        3

         



        0

        3

        1

        11

        1

        13

        15

        19

        2

        4

        11

        16

        3

        16

        1

        5

        4

        1

        5

        1

        5

        1

        38

        3

        6

        7

         

        14

        7

        12

        26

        2

        8

         

        3

        7

        9

        15

        3

         

        Why don't the lines come out from my grid?

        0

        3

        1

        11

        1

        13

        15

        19

        2

        4

        11

        16

        3

        16

        1

        5

        4

        1

        5

        1

        5

        1

        38

        3

        6

        7

         

        14

        7

        12

        26

        2

        8

         

        3

        7

        9

        15

        3

         

        Play to win!

          jackpotismine's avatar - kanji for_peace.jpg
          Kunming
          China
          Member #57910
          January 23, 2008
          3626 Posts
          Offline
          Posted: December 30, 2010, 2:09 am - IP Logged

          Thanks. I least it's better than before.

          Play to win!

            jackpotismine's avatar - kanji for_peace.jpg
            Kunming
            China
            Member #57910
            January 23, 2008
            3626 Posts
            Offline
            Posted: December 30, 2010, 2:11 am - IP Logged

            How did you print screen the icons from lotterypost onto your reply?

            Play to win!

              Avatar
              Florida
              United States
              Member #66575
              October 30, 2008
              3549 Posts
              Offline
              Posted: December 30, 2010, 2:17 am - IP Logged

              How did you print screen the icons from lotterypost onto your reply?

              Screen Capture

               

              I have Windows 7 and used the snipping tool , saved as a jpg and imported as an image. Couldnt get it to just copy and paste

              I dont know how to get the grids unless I use borders in excel on the area I want to copy.

              903903OEEHLL123
              021021EEOLLL033
              499499EOOLHH224
              477477EOOLHH189
              422422EEELLL088
              793793OOOHHL191
              498498EOELHH213
              462462EEELHL123
              578578OOEHHH202
              262262EEELHL101

               

              CarliG

                jackpotismine's avatar - kanji for_peace.jpg
                Kunming
                China
                Member #57910
                January 23, 2008
                3626 Posts
                Offline
                Posted: December 30, 2010, 2:19 am - IP Logged

                Screen Capture

                 

                I have Windows 7 and used the snipping tool , saved as a jpg and imported as an image. Couldnt get it to just copy and paste

                I dont know how to get the grids unless I use borders in excel on the area I want to copy.

                903903OEEHLL123
                021021EEOLLL033
                499499EOOLHH224
                477477EOOLHH189
                422422EEELLL088
                793793OOOHHL191
                498498EOELHH213
                462462EEELHL123
                578578OOEHHH202
                262262EEELHL101

                 

                CarliG

                Thanks. I see.

                Play to win!

                  LottoChica23's avatar - Aquarius
                  Fughedaboutit (NY)
                  United States
                  Member #8160
                  October 26, 2004
                  6777 Posts
                  Offline
                  Posted: December 30, 2010, 9:28 am - IP Logged

                  I'm confused. Everytime I try to cut and paste an excel portion of a sheet to lotterypost, it comes out nothing like what's on my excel program. Here is an example of what I mean:              These numbers should be shown vertical. What am I doing wrong? I seen other posters post there excel sheets and it look normal. Any help would be appreciated.  I'm using excel 2002 SP3.  Can I capture screen and paste on here?

                  8 6 9 8 0 4 5 3 7 0 8 5 2 9 5 2 4 5 1 9 4 6 3 8 0 9 7 4 6 9 
                  T

                   


                  Try copying from Excel then pasting into a Word document (you may have to save it). Then copy from Word and  paste to LP using the paste from Word icon.  That should preserve the formatting of the Excel information.

                  HTH,

                  LC23

                  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

                    jackpotismine's avatar - kanji for_peace.jpg
                    Kunming
                    China
                    Member #57910
                    January 23, 2008
                    3626 Posts
                    Offline
                    Posted: December 30, 2010, 9:34 am - IP Logged

                    0

                    4

                    2

                     

                    1

                    14

                     

                    20

                    2

                    5

                    12

                    17

                    3

                    17

                    2

                    6

                    4

                    2

                    6

                    2

                    5

                     

                    39

                    4

                    6

                    8

                    1

                    15

                    7

                    13

                    27

                    3

                    8

                    1

                    4

                    8

                    9

                    16

                    4

                    1

                    Thanks LC23. I'm gonna try that now. Thanks.

                    0

                    4

                    2

                     

                    1

                    14

                     

                    20

                    2

                    5

                    12

                    17

                    3

                    17

                    2

                    6

                    4

                    2

                    6

                    2

                    5

                     

                    39

                    4

                    6

                    8

                    1

                    15

                    7

                    13

                    27

                    3

                    8

                    1

                    4

                    8

                    9

                    16

                    4

                    1

                    Play to win!

                      jackpotismine's avatar - kanji for_peace.jpg
                      Kunming
                      China
                      Member #57910
                      January 23, 2008
                      3626 Posts
                      Offline
                      Posted: December 30, 2010, 9:47 am - IP Logged

                      I didn't get the grid even though I did what you suggested however I was able to get the grid lines by using the functions in the lotterypost edit features  below.

                      Play to win!

                        four4me's avatar - gate1
                        MD
                        United States
                        Member #1701
                        June 18, 2003
                        8394 Posts
                        Offline
                        Posted: December 30, 2010, 9:38 pm - IP Logged

                        The person to ask about this is Todd he has the formatting protocol.

                        Copy the link to this send him a PM and he will get back to you.

                        I too have had trouble posting stuff from excel but i just worked around it through trial and error and editing using the rich format editor.

                        Big John says. You don't hit the number. The number hits you!!!!

                                       I'm not Big John, I'm Four4me, Big John's a friend.

                          United States
                          Member #75358
                          June 1, 2009
                          5345 Posts
                          Offline
                          Posted: December 30, 2010, 9:53 pm - IP Logged

                          capture

                          Thanx carliG. I always wanted to know how you did this. I too have Windows 7 and found the snipping tool.....Awesome !

                          Now....I have no idea what I'm gonna use this for but.....lol.......Green laugh

                            Avatar
                            New Member

                            United Kingdom
                            Member #103189
                            December 31, 2010
                            1 Posts
                            Offline
                            Posted: January 1, 2011, 7:49 am - IP Logged

                            I'm confused. Everytime I try to cut and paste an excel portion of a sheet to lotterypost, it comes out nothing like what's on my excel program. Here is an example of what I mean:              These numbers should be shown vertical. What am I doing wrong? I seen other posters post there excel sheets and it look normal. Any help would be appreciated.  I'm using excel 2002 SP3.  Can I capture screen and paste on here?

                            8 6 9 8 0 4 5 3 7 0 8 5 2 9 5 2 4 5 1 9 4 6 3 8 0 9 7 4 6 9 
                            T

                             


                            Try copying one vertical column at a time and paste each one into each column in excel. You will have to do this 6 times - it's quite time consuming !!