Using excel and cut and paste on Lottery PostPrev TopicNext Topic

• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 1:45 am

  ▲▼

  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
  

   

  
  

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  Dec 30, 2010, 1:55 am

  ▲▼
  In response to jackpotismine

  Quote: Originally posted by jackpotismine on Dec 30, 2010

  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"

  

   

  903	9	0	3	OEE	HLL	12	3
  021	0	2	1	EEO	LLL	03	3
  499	4	9	9	EOO	LHH	22	4
  477	4	7	7	EOO	LHH	18	9
  422	4	2	2	EEE	LLL	08	8
  793	7	9	3	OOO	HHL	19	1
  498	4	9	8	EOE	LHH	21	3
  462	4	6	2	EEE	LHL	12	3
  578	5	7	8	OOE	HHH	20	2
  262	2	6	2	EEE	LHL	10	1

   

  CarliG
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 2:00 am

  ▲▼

  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

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 2:05 am

  ▲▼
  In response to jackpotismine

  Quote: Originally posted by jackpotismine on Dec 30, 2010

  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

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 2:09 am

  ▲▼

  Thanks. I least it's better than before.

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 2:11 am

  ▲▼

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

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  Dec 30, 2010, 2:17 am

  ▲▼
  In response to jackpotismine

  Quote: Originally posted by jackpotismine on Dec 30, 2010

  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.

  903	9	0	3	OEE	HLL	12	3
  021	0	2	1	EEO	LLL	03	3
  499	4	9	9	EOO	LHH	22	4
  477	4	7	7	EOO	LHH	18	9
  422	4	2	2	EEE	LLL	08	8
  793	7	9	3	OOO	HHL	19	1
  498	4	9	8	EOE	LHH	21	3
  462	4	6	2	EEE	LHL	12	3
  578	5	7	8	OOE	HHH	20	2
  262	2	6	2	EEE	LHL	10	1

   

  CarliG
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 2:19 am

  ▲▼
  In response to CarliG

  Quote: Originally posted by CarliG on Dec 30, 2010

  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.

  903	9	0	3	OEE	HLL	12	3
  021	0	2	1	EEO	LLL	03	3
  499	4	9	9	EOO	LHH	22	4
  477	4	7	7	EOO	LHH	18	9
  422	4	2	2	EEE	LLL	08	8
  793	7	9	3	OOO	HHL	19	1
  498	4	9	8	EOE	LHH	21	3
  462	4	6	2	EEE	LHL	12	3
  578	5	7	8	OOE	HHH	20	2
  262	2	6	2	EEE	LHL	10	1

   

  CarliG

  Thanks. I see.

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• LottoChica23

  

  Fughedaboutit (NY)
  United States
  Member #8,160
  October 26, 2004
  6,776 Posts
  Offline
  Dec 30, 2010, 9:28 am

  ▲▼
  In response to jackpotismine

  Quote: Originally posted by jackpotismine on Dec 30, 2010

  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...
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 9:34 am

  ▲▼

  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

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Dec 30, 2010, 9:47 am

  ▲▼

  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.

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• four4me

  

  MD
  United States
  Member #1,701
  June 18, 2003
  10,731 Posts
  Offline
  Dec 30, 2010, 9:38 pm

  ▲▼

  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.
• joker17

  United States
  Member #75,356
  June 1, 2009
  5,345 Posts
  Offline
  Dec 30, 2010, 9:53 pm

  ▲▼

  

  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.......
• petinuk

  

  United Kingdom
  Member #103,185
  December 31, 2010
  1 Post
  Offline
  Jan 1, 2011, 7:49 am

  ▲▼
  In response to jackpotismine

  Quote: Originally posted by jackpotismine on Dec 30, 2010

  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 !!