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

Excel Question

Topic closed. 4 replies. Last post 11 years ago by LottoChica23.

Page 1 of 1
PrintE-mailLink
LottoChica23's avatar - Aquarius
Fughedaboutit (NY)
United States
Member #8160
October 26, 2004
6777 Posts
Online
Posted: January 2, 2006, 2:08 pm - IP Logged

When I copy and paste lottery results from various sites into an Excel spreadsheet and the number is in the x-x-x format (has dashes), Excel reads the number as a date. Is there any way that I can reformat the x-x-x number not to read as a date but instead as a number XXX? I can't seem to  figure this one out. Disapprove

Any assistance would be greatly appreciated.

Thanks 

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: January 2, 2006, 2:26 pm - IP Logged

    Did you try changing the format to text once you have copied & pasted? 

    L ttaL   T

      hypersoniq's avatar - 8ball
      Pennsylvania
      United States
      Member #1340
      April 6, 2003
      2450 Posts
      Offline
      Posted: January 2, 2006, 2:27 pm - IP Logged

      put them into a text file (notepad.exe) first, then import into the excel sheet from

      the Data menu item

      --> Import External Data submenu

      ------->Import Data... on the sub-sub menu

      this opens up the "Select Data Source" dialog box.

      let's say you have a text file named "Drawings.txt" containing the following data...

      4-5-6
      8-7-5
      4-6-5
      2-8-5
      4-6-5
      2-5-7
      4-6-2
      4-1-1

      you select the drawings.txt file from the Select Data Source dialog box (after navigating to it's location)

      this opens the Text Import Wizard...

      Step one of 3... choose the Delimited Radio button (default) because the numbers are separated by a character such as - or , etc...

      Step 2 of 3... choose the delimiter  (check the "Other" box and in the space provided, enter a - )

      Step 3 of 3... select data formats  (you can skip this unless you are also importing a date, then simply make the date column the DATE data type and skip the rest)

      click Finish...then select the cell where you want the data  (A1 by default on a blank sheet)

      and it goes right into the worksheet.

      Playing more than one ticket per game is betting against yourself.

        LottoChica23's avatar - Aquarius
        Fughedaboutit (NY)
        United States
        Member #8160
        October 26, 2004
        6777 Posts
        Online
        Posted: January 2, 2006, 2:39 pm - IP Logged

        Thanks Guys, I will try your suggestions...

          LottoChica23's avatar - Aquarius
          Fughedaboutit (NY)
          United States
          Member #8160
          October 26, 2004
          6777 Posts
          Online
          Posted: January 2, 2006, 3:59 pm - IP Logged

          Worked like a charm! LOL