Welcome Guest
Log In | Register )
You last visited December 7, 2016, 1:12 pm
All times shown are
Eastern Time (GMT-5:00)

Past Draw Results to an Excel Spreadsheet

Topic closed. 3 replies. Last post 7 years ago by floridian.

Page 1 of 1
PrintE-mailLink
floridian's avatar - DiscoBallGlowing

United States
Member #45802
August 28, 2006
335 Posts
Offline
Posted: March 7, 2010, 6:25 pm - IP Logged

Can anyone advise me how to acquire past Cash3 and Pick4 resluts in a form that can be entered into an Excell Spreadsheet?  I am new at the process but it seems there are plenty of places to acquire the data however, when you copy and paste ithe data it is viewed by Excel as a date and their seems no way to change it.  It is probably is a simple task but it is not apparent to me.  Amy help appreciated.

Floridian

    Fibonacci's avatar - Lottery-050.jpg
    New York, NY
    United States
    Member #39471
    May 16, 2006
    2696 Posts
    Offline
    Posted: March 8, 2010, 4:46 pm - IP Logged

    Can anyone advise me how to acquire past Cash3 and Pick4 resluts in a form that can be entered into an Excell Spreadsheet?  I am new at the process but it seems there are plenty of places to acquire the data however, when you copy and paste ithe data it is viewed by Excel as a date and their seems no way to change it.  It is probably is a simple task but it is not apparent to me.  Amy help appreciated.

    Floridian

    The column where the draws go--format it to be text only first. Then paste your data in again.

    Highlight column in which the draws will go

    Right click the column in which the draws will go and click "format cells."

    Highlight (place cursor) on Text

    Click OK to close

    Paste your data again.

    $$$

      Hermanus104's avatar - 5027340606 1e360c8038_s.jpg
      Northern Virginia
      United States
      Member #83350
      December 5, 2009
      1315 Posts
      Offline
      Posted: March 8, 2010, 6:47 pm - IP Logged

      The column where the draws go--format it to be text only first. Then paste your data in again.

      Highlight column in which the draws will go

      Right click the column in which the draws will go and click "format cells."

      Highlight (place cursor) on Text

      Click OK to close

      Paste your data again.

      This is the right answer, although I prefer my own method: shout at the computer until it obeys you.

      Today's winning 3-ball is going to be a number between 000 and 999.

      In a lot of states, lotteries benefit education. That makes the REAL winners the only people who can't play!

        floridian's avatar - DiscoBallGlowing

        United States
        Member #45802
        August 28, 2006
        335 Posts
        Offline
        Posted: March 8, 2010, 11:27 pm - IP Logged

        The column where the draws go--format it to be text only first. Then paste your data in again.

        Highlight column in which the draws will go

        Right click the column in which the draws will go and click "format cells."

        Highlight (place cursor) on Text

        Click OK to close

        Paste your data again.

        Thankyou Sir!!!