SBR spreadsheet download to Excel - help - can't get date correct

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cyberbabble
    SBR Wise Guy
    • 08-30-10
    • 772

    #1
    SBR spreadsheet download to Excel - help - can't get date correct
    I am downloading my SBR spreadsheet to Excel. Everything is OK except the date. Date shows as an integer. Excel format cell option just gives me ######.
    Can anybody help?
    Thanks
  • LtDementia
    SBR High Roller
    • 08-22-10
    • 203

    #2
    Originally posted by cyberbabble
    I am downloading my SBR spreadsheet to Excel. Everything is OK except the date. Date shows as an integer. Excel format cell option just gives me ######.
    Can anybody help?
    Thanks
    Maybe try widening the date column??

    LtD
    Comment
    • SteveRyan
      SBR MVP
      • 11-15-11
      • 1654

      #3
      Originally posted by cyberbabble
      I am downloading my SBR spreadsheet to Excel. Everything is OK except the date. Date shows as an integer. Excel format cell option just gives me ######.
      Can anybody help?
      Thanks
      Excel does not recognize the date format from SBR. How is it written on your SBR spreadsheet?
      Comment
      • EXhoosier10
        SBR MVP
        • 07-06-09
        • 3122

        #4
        highlight the cell and hit Ctrl+h+v+n+(type "short") hit enter
        Comment
        • nhjxmen
          SBR Rookie
          • 04-12-12
          • 10

          #5
          Are you programming yourself or using someone else's program? I've been trying to figure how to import into excel for a long time now. Any tips?
          Comment
          • drawster
            SBR Rookie
            • 11-03-13
            • 23

            #6
            in Excel you have the data tab and you have an option to extract data from an html.

            if you want to automate it... before extracting the data, go to the developer tab ->record macro -> after extracting stop the recording and view the macro code-> start learning a little vba -> modify at your will
            Comment
            • satana
              SBR Hustler
              • 01-05-13
              • 71

              #7
              what's this SBR spreadsheet? is it downloadable for free?
              Comment
              SBR Contests
              Collapse
              Top-Rated US Sportsbooks
              Collapse
              Working...