MS Excel, pasting tables into Lotterypost threads.Prev TopicNext Topic

• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Dec 9, 2012, 12:00 pm

  ▲▼

  Select at range in Excel and paste it into the message box. You loose the layout/format.

  1	2	3	4	5	6	7	8	9	10	11	12	right
  6	8	9	10	12	13	14	16	17	19	21	24	9, 4, 5, 6
  8	9	10	12	13	14	17	18	19	20	21	22	9, 6, 5, 5
  4	5	8	9	10	12	13	14	15	17	19	21	7, 6, 7, 5
  6	8	9	10	13	14	15	17	18	19	20	24	8, 4, 5, 7
  5	8	9	10	13	14	15	16	17	18	21	24	8, 4, 5, 6
  1	4	5	6	8	9	10	13	14	15	17	24	6, 5, 6, 6
  5	6	8	9	10	12	13	15	16	17	18	19	9, 6, 7, 6
  6	8	9	10	13	16	17	18	20	21	22	24	10, 4, 4, 6
  6	8	9	10	12	13	14	15	16	18	20	21	8, 3, 6, 6

  In order to keep some layout, use the conditional format in MS Excel.

  1	2	3	4	5	6	7	8	9	10	11	12	right
  6	8	9	10	12	13	14	16	17	19	21	24	9, 4, 5, 6
  8	9	10	12	13	14	17	18	19	20	21	22	9, 6, 5, 5
  4	5	8	9	10	12	13	14	15	17	19	21	7, 6, 7, 5
  6	8	9	10	13	14	15	17	18	19	20	24	8, 4, 5, 7
  5	8	9	10	13	14	15	16	17	18	21	24	8, 4, 5, 6
  1	4	5	6	8	9	10	13	14	15	17	24	6, 5, 6, 6
  5	6	8	9	10	12	13	15	16	17	18	19	9, 6, 7, 6
  6	8	9	10	13	16	17	18	20	21	22	24	10, 4, 4, 6
  6	8	9	10	12	13	14	15	16	18	20	21	8, 3, 6, 6

  To center the content, you need to select the cell values with the cursor/mouse inside of the table and click on the center-button, under the message box. This way you don't loose the format.

  1	2	3	4	5	6	7	8	9	10	11	12	right
  6	8	9	10	12	13	14	16	17	19	21	24	9, 4, 5, 6
  8	9	10	12	13	14	17	18	19	20	21	22	9, 6, 5, 5
  4	5	8	9	10	12	13	14	15	17	19	21	7, 6, 7, 5
  6	8	9	10	13	14	15	17	18	19	20	24	8, 4, 5, 7
  5	8	9	10	13	14	15	16	17	18	21	24	8, 4, 5, 6
  1	4	5	6	8	9	10	13	14	15	17	24	6, 5, 6, 6
  5	6	8	9	10	12	13	15	16	17	18	19	9, 6, 7, 6
  6	8	9	10	13	16	17	18	20	21	22	24	10, 4, 4, 6
  6	8	9	10	12	13	14	15	16	18	20	21	8, 3, 6, 6

  I hope that this contribution was a help to all members who are posting tables or intend to do this.

  Other tips:

  • Empty spaces can be filled with non breaking spaces to prevent cells from disappearing.
    Another option would be to use the conditional format again. For this you can put a "-" and give the font the background-color.

  • Use the -button to check the spelling.
  • Condition conditional format for formulas: =TRUE.
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,811 Posts
  Offline
  Dec 9, 2012, 12:26 pm

  ▲▼

  Direct paste and modification in LP.

  Index	Regression	Wave 1	Wave 2	Wave 3	Wave 4	Wave 5	Wave 6	Wave 7	Wave 8	Wave 9	Wave 10	Wave 11	Wave 12	Remainder	Data
  1	2.313458539	0.384312956	0.17343884	0.097455385	0.064609119	-0.037528994	-0.001412214	0.00270631	0.001051589	0.000459051	0.000335274	0.000286892	0.000236965	0.000590287	3
  2	2.314831525	0.384780175	0.172944347	0.095006646	0.070851513	-0.037237567	-0.009274671	-0.00188638	-0.001968518	-0.002023172	-0.00172318	-0.001316116	-0.000960673	-0.002023929	2.98
  3	2.316205326	0.385253544	0.172410092	0.09203462	0.07988103	-0.028774646	-0.007334546	0.005820905	0.007177155	0.005696812	0.003978318	0.002641448	0.0017467	0.003263243	3.04
  4	2.317579941	0.385733089	0.171837204	0.088552653	0.090483816	-0.017115377	-0.033341147	-0.020759723	-0.01225532	-0.007447255	-0.004665318	-0.002976101	-0.0019473	-0.003679162	2.95
  5	2.318955373	0.38621884	0.171226891	0.084577326	0.101091584	0.025874928	0.003136158	0.002376282	0.003372265	0.00337194	0.002808966	0.002125524	0.001548965	0.003314959	3.11
  6	2.320331621	0.386710823	0.17058043	0.080128854	0.109252857	0.064902946	0.024674935	0.005008233	-0.000982635	-0.002388756	-0.00228701	-0.001794403	-0.001319125	-0.00281877	3.15
  7	2.321708686	0.387209067	0.169899163	0.075231586	0.112853931	0.084726679	0.043768599	0.020006484	0.010271044	0.005658154	0.003274403	0.001963841	0.00122731	0.002201054	3.24
  8	2.323086568	0.387713601	0.169184488	0.069914278	0.110647527	0.065746483	0.007331487	-0.003841851	-0.003564164	-0.002335082	-0.001435347	-0.000877605	-0.000552106	-0.001018278	3.12
  9	2.324465267	0.388224455	0.168437856	0.064210272	0.102898743	0.042243792	-0.014759842	-0.012937437	-0.006692054	-0.003201133	-0.001514952	-0.000720748	-0.00034976	-0.00030446	3.05
  10	2.325844785	0.388741657	0.167660763	0.05815735	0.090503429	0.033001105	-0.002444332	0.000418553	0.002242893	0.002055305	0.001440871	0.000920183	0.000574689	0.000882748	3.07
  11	2.327225122	0.389265237	0.16685474	0.051797417	0.074394189	0.025047298	0.003338629	0.002419215	0.001175713	0.00016872	-0.000272331	-0.000365223	-0.000323699	-0.000725028	3.04

   

  Passing through our old Microsoft FrontPage program.

  Index	Regression	Wave 1	Wave 2	Wave 3	Wave 4	Wave 5	Wave 6	Wave 7	Wave 8	Wave 9	Wave 10	Wave 11	Wave 12	Remainder	Data
  1	2.313458539	0.384312956	0.17343884	0.097455385	0.064609119	-0.037528994	-0.001412214	0.00270631	0.001051589	0.000459051	0.000335274	0.000286892	0.000236965	0.000590287	3
  2	2.314831525	0.384780175	0.172944347	0.095006646	0.070851513	-0.037237567	-0.009274671	-0.00188638	-0.001968518	-0.002023172	-0.00172318	-0.001316116	-0.000960673	-0.002023929	2.98
  3	2.316205326	0.385253544	0.172410092	0.09203462	0.07988103	-0.028774646	-0.007334546	0.005820905	0.007177155	0.005696812	0.003978318	0.002641448	0.0017467	0.003263243	3.04
  4	2.317579941	0.385733089	0.171837204	0.088552653	0.090483816	-0.017115377	-0.033341147	-0.020759723	-0.01225532	-0.007447255	-0.004665318	-0.002976101	-0.0019473	-0.003679162	2.95
  5	2.318955373	0.38621884	0.171226891	0.084577326	0.101091584	0.025874928	0.003136158	0.002376282	0.003372265	0.00337194	0.002808966	0.002125524	0.001548965	0.003314959	3.11
  6	2.320331621	0.386710823	0.17058043	0.080128854	0.109252857	0.064902946	0.024674935	0.005008233	-0.000982635	-0.002388756	-0.00228701	-0.001794403	-0.001319125	-0.00281877	3.15
  7	2.321708686	0.387209067	0.169899163	0.075231586	0.112853931	0.084726679	0.043768599	0.020006484	0.010271044	0.005658154	0.003274403	0.001963841	0.00122731	0.002201054	3.24
  8	2.323086568	0.387713601	0.169184488	0.069914278	0.110647527	0.065746483	0.007331487	-0.003841851	-0.003564164	-0.002335082	-0.001435347	-0.000877605	-0.000552106	-0.001018278	3.12
  9	2.324465267	0.388224455	0.168437856	0.064210272	0.102898743	0.042243792	-0.014759842	-0.012937437	-0.006692054	-0.003201133	-0.001514952	-0.000720748	-0.00034976	-0.00030446	3.05
  10	2.325844785	0.388741657	0.167660763	0.05815735	0.090503429	0.033001105	-0.002444332	0.000418553	0.002242893	0.002055305	0.001440871	0.000920183	0.000574689	0.000882748	3.07
  11	2.327225122	0.389265237	0.16685474	0.051797417	0.074394189	0.025047298	0.003338629	0.002419215	0.001175713	0.00016872	-0.000272331	-0.000365223	-0.000323699	-0.000725028	3.04

   

  Passing through Microsoft Word

  Index	Regression	Wave 1	Wave 2	Wave 3	Wave 4	Wave 5	Wave 6	Wave 7	Wave 8	Wave 9	Wave 10	Wave 11	Wave 12	Remainder	Data
  1	2.313458539	0.384312956	0.17343884	0.097455385	0.064609119	-0.037528994	-0.001412214	0.00270631	0.001051589	0.000459051	0.000335274	0.000286892	0.000236965	0.000590287	3
  2	2.314831525	0.384780175	0.172944347	0.095006646	0.070851513	-0.037237567	-0.009274671	-0.00188638	-0.001968518	-0.002023172	-0.00172318	-0.001316116	-0.000960673	-0.002023929	2.98
  3	2.316205326	0.385253544	0.172410092	0.09203462	0.07988103	-0.028774646	-0.007334546	0.005820905	0.007177155	0.005696812	0.003978318	0.002641448	0.0017467	0.003263243	3.04
  4	2.317579941	0.385733089	0.171837204	0.088552653	0.090483816	-0.017115377	-0.033341147	-0.020759723	-0.01225532	-0.007447255	-0.004665318	-0.002976101	-0.0019473	-0.003679162	2.95
  5	2.318955373	0.38621884	0.171226891	0.084577326	0.101091584	0.025874928	0.003136158	0.002376282	0.003372265	0.00337194	0.002808966	0.002125524	0.001548965	0.003314959	3.11
  6	2.320331621	0.386710823	0.17058043	0.080128854	0.109252857	0.064902946	0.024674935	0.005008233	-0.000982635	-0.002388756	-0.00228701	-0.001794403	-0.001319125	-0.00281877	3.15
  7	2.321708686	0.387209067	0.169899163	0.075231586	0.112853931	0.084726679	0.043768599	0.020006484	0.010271044	0.005658154	0.003274403	0.001963841	0.00122731	0.002201054	3.24
  8	2.323086568	0.387713601	0.169184488	0.069914278	0.110647527	0.065746483	0.007331487	-0.003841851	-0.003564164	-0.002335082	-0.001435347	-0.000877605	-0.000552106	-0.001018278	3.12
  9	2.324465267	0.388224455	0.168437856	0.064210272	0.102898743	0.042243792	-0.014759842	-0.012937437	-0.006692054	-0.003201133	-0.001514952	-0.000720748	-0.00034976	-0.00030446	3.05
  10	2.325844785	0.388741657	0.167660763	0.05815735	0.090503429	0.033001105	-0.002444332	0.000418553	0.002242893	0.002055305	0.001440871	0.000920183	0.000574689	0.000882748	3.07
  11	2.327225122	0.389265237	0.16685474	0.051797417	0.074394189	0.025047298	0.003338629	0.002419215	0.001175713	0.00016872	-0.000272331	-0.000365223	-0.000323699	-0.000725028	3.04

   

  Passing through Microsoft Expression Web

  Index	Regression	Wave 1	Wave 2	Wave 3	Wave 4	Wave 5	Wave 6	Wave 7	Wave 8	Wave 9	Wave 10	Wave 11	Wave 12	Remainder	Data
  1	2.313458539	0.384312956	0.17343884	0.097455385	0.064609119	-0.037528994	-0.001412214	0.00270631	0.001051589	0.000459051	0.000335274	0.000286892	0.000236965	0.000590287	3
  2	2.314831525	0.384780175	0.172944347	0.095006646	0.070851513	-0.037237567	-0.009274671	-0.00188638	-0.001968518	-0.002023172	-0.00172318	-0.001316116	-0.000960673	-0.002023929	2.98
  3	2.316205326	0.385253544	0.172410092	0.09203462	0.07988103	-0.028774646	-0.007334546	0.005820905	0.007177155	0.005696812	0.003978318	0.002641448	0.0017467	0.003263243	3.04
  4	2.317579941	0.385733089	0.171837204	0.088552653	0.090483816	-0.017115377	-0.033341147	-0.020759723	-0.01225532	-0.007447255	-0.004665318	-0.002976101	-0.0019473	-0.003679162	2.95
  5	2.318955373	0.38621884	0.171226891	0.084577326	0.101091584	0.025874928	0.003136158	0.002376282	0.003372265	0.00337194	0.002808966	0.002125524	0.001548965	0.003314959	3.11
  6	2.320331621	0.386710823	0.17058043	0.080128854	0.109252857	0.064902946	0.024674935	0.005008233	-0.000982635	-0.002388756	-0.00228701	-0.001794403	-0.001319125	-0.00281877	3.15
  7	2.321708686	0.387209067	0.169899163	0.075231586	0.112853931	0.084726679	0.043768599	0.020006484	0.010271044	0.005658154	0.003274403	0.001963841	0.00122731	0.002201054	3.24
  8	2.323086568	0.387713601	0.169184488	0.069914278	0.110647527	0.065746483	0.007331487	-0.003841851	-0.003564164	-0.002335082	-0.001435347	-0.000877605	-0.000552106	-0.001018278	3.12
  9	2.324465267	0.388224455	0.168437856	0.064210272	0.102898743	0.042243792	-0.014759842	-0.012937437	-0.006692054	-0.003201133	-0.001514952	-0.000720748	-0.00034976	-0.00030446	3.05
  10	2.325844785	0.388741657	0.167660763	0.05815735	0.090503429	0.033001105	-0.002444332	0.000418553	0.002242893	0.002055305	0.001440871	0.000920183	0.000574689	0.000882748	3.07
  11	2.327225122	0.389265237	0.16685474	0.051797417	0.074394189	0.025047298	0.003338629	0.002419215	0.001175713	0.00016872	-0.000272331	-0.000365223	-0.000323699	-0.000725028	3.04

  The One Over None
  I Know...
• JKING

  

  United States
  Member #5,599
  July 13, 2004
  1,207 Posts
  Offline
  Dec 13, 2012, 11:23 am

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Dec 9, 2012

  Select at range in Excel and paste it into the message box. You loose the layout/format.

  1	2	3	4	5	6	7	8	9	10	11	12	right
  6	8	9	10	12	13	14	16	17	19	21	24	9, 4, 5, 6
  8	9	10	12	13	14	17	18	19	20	21	22	9, 6, 5, 5
  4	5	8	9	10	12	13	14	15	17	19	21	7, 6, 7, 5
  6	8	9	10	13	14	15	17	18	19	20	24	8, 4, 5, 7
  5	8	9	10	13	14	15	16	17	18	21	24	8, 4, 5, 6
  1	4	5	6	8	9	10	13	14	15	17	24	6, 5, 6, 6
  5	6	8	9	10	12	13	15	16	17	18	19	9, 6, 7, 6
  6	8	9	10	13	16	17	18	20	21	22	24	10, 4, 4, 6
  6	8	9	10	12	13	14	15	16	18	20	21	8, 3, 6, 6

  In order to keep some layout, use the conditional format in MS Excel.

  1	2	3	4	5	6	7	8	9	10	11	12	right
  6	8	9	10	12	13	14	16	17	19	21	24	9, 4, 5, 6
  8	9	10	12	13	14	17	18	19	20	21	22	9, 6, 5, 5
  4	5	8	9	10	12	13	14	15	17	19	21	7, 6, 7, 5
  6	8	9	10	13	14	15	17	18	19	20	24	8, 4, 5, 7
  5	8	9	10	13	14	15	16	17	18	21	24	8, 4, 5, 6
  1	4	5	6	8	9	10	13	14	15	17	24	6, 5, 6, 6
  5	6	8	9	10	12	13	15	16	17	18	19	9, 6, 7, 6
  6	8	9	10	13	16	17	18	20	21	22	24	10, 4, 4, 6
  6	8	9	10	12	13	14	15	16	18	20	21	8, 3, 6, 6

  To center the content, you need to select the cell values with the cursor/mouse inside of the table and click on the center-button, under the message box. This way you don't loose the format.

  1	2	3	4	5	6	7	8	9	10	11	12	right
  6	8	9	10	12	13	14	16	17	19	21	24	9, 4, 5, 6
  8	9	10	12	13	14	17	18	19	20	21	22	9, 6, 5, 5
  4	5	8	9	10	12	13	14	15	17	19	21	7, 6, 7, 5
  6	8	9	10	13	14	15	17	18	19	20	24	8, 4, 5, 7
  5	8	9	10	13	14	15	16	17	18	21	24	8, 4, 5, 6
  1	4	5	6	8	9	10	13	14	15	17	24	6, 5, 6, 6
  5	6	8	9	10	12	13	15	16	17	18	19	9, 6, 7, 6
  6	8	9	10	13	16	17	18	20	21	22	24	10, 4, 4, 6
  6	8	9	10	12	13	14	15	16	18	20	21	8, 3, 6, 6

  I hope that this contribution was a help to all members who are posting tables or intend to do this.

  Other tips:

  • Empty spaces can be filled with non breaking spaces to prevent cells from disappearing.
    Another option would be to use the conditional format again. For this you can put a "-" and give the font the background-color.

  • Use the -button to check the spelling.
  • Condition conditional format for formulas: =TRUE.

  I failed the class. *L*

  "conditional format"...

  Where is that in excel?

  Is there a step by step for us dumbos?
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Dec 13, 2012, 2:11 pm

  ▲▼

  http://office.microsoft.com/en-us/excel-help/quick-start-apply-conditional-formatting-HA010370614.aspx
  (For more detailed information about getting started with conditional formatting, see Add, change, find, or clear conditional formats. )

  http://office.microsoft.com/en-us/excel-help/video-apply-conditional-formatting-VA101829631.aspx?CTT=3
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  Dec 13, 2012, 2:13 pm

  ▲▼

  Great Tip Serge

   

   

  Thanks

   

  Carlig

  
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Dec 13, 2012, 2:17 pm

  ▲▼

  Like JADElottery showed, you can also copy the range and paste it in another program, then copy it again to paste it here.
  With copy paste special you can paste as image. You might also paste to MS Paint.
• JKING

  

  United States
  Member #5,599
  July 13, 2004
  1,207 Posts
  Offline
  Dec 15, 2012, 4:48 pm

  ▲▼

  											FILL   IN RATE FOR 56 NUMBERS %
  	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
  0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  5	100	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  7	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  8	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  9	0	30	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  10	0	67	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  11	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  12	0	0	7	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  13	0	0	24	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  14	0	0	43	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  15	0	0	26	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  16	0	0	0	7	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  17	0	0	0	36	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  18	0	0	0	28	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  19	0	0	0	21	5	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  20	0	0	0	4	21	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  21	0	0	0	0	26	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  22	0	0	0	0	25	8	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  23	0	0	0	0	14	20	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  24	0	0	0	0	3	22	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  25	0	0	0	0	0	18	12	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  26	0	0	0	0	0	20	17	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  27	0	0	0	0	0	4	17	7	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  28	0	0	0	0	0	3	23	9	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  29	0	0	0	0	0	0	13	21	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  30	0	0	0	0	0	0	9	26	12	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  31	0	0	0	0	0	0	0	16	16	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  32	0	0	0	0	0	0	1	10	18	4	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  33	0	0	0	0	0	0	0	3	24	23	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  34	0	0	0	0	0	0	0	2	14	18	12	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  35	0	0	0	0	0	0	0	0	7	27	12	7	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  36	0	0	0	0	0	0	0	0	2	11	25	8	5	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  37	0	0	0	0	0	0	0	0	0	5	21	16	9	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  38	0	0	0	0	0	0	0	0	0	2	17	29	13	9	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  39	0	0	0	0	0	0	0	0	0	1	2	14	15	12	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
  40	0	0	0	0	0	0	0	0	0	1	2	13	27	11	16	4	1	0	0	0	0	0	0	0	0	0	0	0	0	0
  41	0	0	0	0	0	0	0	0	0	0	2	7	15	24	14	11	1	0	0	0	0	0	0	0	0	0	0	0	0	0
  42	0	0	0	0	0	0	0	0	0	0	0	2	9	21	11	12	4	1	0	0	0	0	0	0	0	0	0	0	0	0
  43	0	0	0	0	0	0	0	0	0	0	0	0	5	14	30	22	20	8	0	0	0	0	0	0	0	0	0	0	0	0
  44	0	0	0	0	0	0	0	0	0	0	0	0	0	5	13	22	20	14	9	1	0	0	0	0	0	0	0	0	0	0
  45	0	0	0	0	0	0	0	0	0	0	0	0	0	1	9	22	29	28	17	10	2	0	0	0	0	0	0	0	0	0
  46	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	14	20	23	18	15	4	0	0	0	0	0	0	0	0
  47	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	9	23	28	22	14	11	9	4	3	2	1	0	0	0
  48	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	15	34	30	27	13	7	2	1	1	1	0	0
  49	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	2	4	8	24	30	29	20	11	5	4	3	2	0
  50	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	4	10	18	33	40	29	16	10	5	5	4
  51	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	2	2	1	3	10	20	35	45	34	27	17	12
  52	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	3	5	5	8	15	24	39	39	38	32
  53	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	7	10	22	33	43
  54	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	2	4	8
  55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1
  56	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

   Got it, thanks. TinyMCE really should accommodated excel better.
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 5, 2013, 2:35 pm

  ▲▼

  If I copy paste directly into excel the following happens.

  6

  9

  24

  25

  34

  2

  14

  0

  8

  2O/3E

   oh, nothing happened,

  the webpage and excel happend to freeze for about a minute, but it seems the formatting remained.

  That was not always the case from my prior experience.
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 5, 2013, 2:37 pm

  ▲▼
  In response to LottoBoner

  Quote: Originally posted by LottoBoner on Jan 5, 2013

  If I copy paste directly into excel the following happens.

  6

  9

  24

  25

  34

  2

  14

  0

  8

  2O/3E

   oh, nothing happened,

  the webpage and excel happend to freeze for about a minute, but it seems the formatting remained.

  That was not always the case from my prior experience.

  Oh sorry!!! Forgot you dont like pink!
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Jan 5, 2013, 4:30 pm

  ▲▼
  In response to LottoBoner

  Quote: Originally posted by LottoBoner on Jan 5, 2013

  Oh sorry!!! Forgot you dont like pink!

  Maybe you should show your functions for 2O/3E instead.

  
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 6, 2013, 7:35 am

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Jan 5, 2013

  Maybe you should show your functions for 2O/3E instead.

  Well I started with this and then I got stuck.

  =IF(DJ1488=2,"3O/2E",0)
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 6, 2013, 7:42 am

  ▲▼

  1	15	1	10	3	a1	1	2	0	2	1	17	19	30	34	101	33	29	17	1	2	2	3	1	3	2	4	2	7	6	5	5	4	1	0		4	10	3	5	0
  22	0	2	6	0	b1	0	0	3	2	22	23	26	33	34	138	12	11	11				0	3	2	0	3	2	3	2	5	2	8	7	7	4	2	0		16	1	5	4	0
  11	2	0	2	14	c1	0	4	0	1	11	14	15	18	33	91	22	7	19				1	3	1	4	0	1	4	5	1	9	6	9	4	7	2	0		5	5	2	12	4
  14	0	3	3	10	d1	0	3	1	1	14	15	19	23	34	105	20	9	19				0	4	1	3	1	1	4	4	2	6	9	5	8	4	1	0		5	2	3	1	0
  1	5	7	3	3	e1	2	2	1	0	1	7	15	19	23	65	22	18	16				2	3	0	4	3	2	3	2	1	7	7	9	5	8	1	0		4	8	2	3	1
• SergeM

  

  Economy class
  Belgium
  Member #123,694
  February 27, 2012
  4,035 Posts
  Offline
  Jan 6, 2013, 12:57 pm

  ▲▼
  In response to LottoBoner

  Quote: Originally posted by LottoBoner on Jan 6, 2013

  Well I started with this and then I got stuck.

  =IF(DJ1488=2,"3O/2E",0)

  =IF(DJ1488=2,"3O/2E",0)+IF(DJ1488=3,"3O/1E",0) &'(?)"

  Can that not help?
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 6, 2013, 2:59 pm

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Jan 6, 2013

  =IF(DJ1488=2,"3O/2E",0)+IF(DJ1488=3,"3O/1E",0) &'(?)"

  Can that not help?

  I will test that in the cell and see if that helps.

  Thanks.
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 6, 2013, 3:06 pm

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Jan 6, 2013

  =IF(DJ1488=2,"3O/2E",0)+IF(DJ1488=3,"3O/1E",0) &'(?)"

  Can that not help?

  =IF(DJ1489=2,"3O/2E",0)+IF(DJ1489=3,"2O/3E",0)&'(?)"

  Sorry, not working.

  Good try though serge.