+ Reply to Thread
Results 1 to 10 of 10

Excel show odds as date

  1. #1
    Registered User
    Join Date
    09-09-2011
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    91

    Excel show odds as date

    Hi

    I attached data to excel and the odds are shown as dates. I attach a sample here. For example E2 is now "helmi.30" and it should be 2,3 and G2 is now "maalis.28" and it should be 3,28. How can i change it so that the odds are no longer mixed to dates...?
    Attached Files Attached Files
    Last edited by Ipinho100; 02-26-2017 at 03:45 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel show odds as date

    Hi Ipinho,

    It sounds like you have those cells as Date Format. Look at this link to see if the answer hides in it.

    http://www.ozgrid.com/Excel/excel-cu...er-formats.htm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Excel show odds as date

    Create a custom number format with this
    ###/###0

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Excel show odds as date

    I did not get it working using that custom number format...

  5. #5
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Excel show odds as date

    Quote Originally Posted by Ipinho100 View Post
    I did not get it working using that custom number format...

    odd...works for me
    I had same problem as if I entered 5/1 then excel would turn into a date but with thus format it shows 5/1

  6. #6
    Registered User
    Join Date
    09-09-2011
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Excel show odds as date

    It is maybe because i am trying to attach desimal odds and not the fractional odds

  7. #7
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Excel show odds as date

    Quote Originally Posted by Ipinho100 View Post
    It is maybe because i am trying to attach desimal odds and not the fractional odds
    My fault. I didn't read opening post correctly
    If it is decimal then just entering but do as Marvin says and format as number
    Last edited by philaugust2004; 02-26-2017 at 03:31 PM.

  8. #8
    Registered User
    Join Date
    09-09-2011
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Excel show odds as date

    I copied the odds from a web site and attached to excel. In the web site they use . instead of , and excel does not recognize it as i would want....

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel show odds as date

    Hi,

    You may need to change your regional settings to accomplish what you want.
    http://blogmines.com/blog/how-to-cha...in-excel-2010/

  10. #10
    Registered User
    Join Date
    09-09-2011
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Excel show odds as date

    Thanks. Just found the same page. Now it works!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to calculate Bookmaker real odds (odds less commission) in Excel 2013 ?
    By sbeekallan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-09-2015, 08:43 AM
  2. Creating a date Sequence with the removal of the odds
    By Mohamed7 in forum Excel General
    Replies: 11
    Last Post: 04-04-2015, 06:21 PM
  3. Scraping bookmakers odds into excel
    By burdo77 in forum Excel General
    Replies: 4
    Last Post: 03-09-2014, 10:33 PM
  4. [SOLVED] need help to lookup a (workday) date, and then excel output to show that date minus 1
    By Marijke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2013, 11:13 AM
  5. Replies: 3
    Last Post: 08-31-2011, 09:11 AM
  6. How to calculate odds in excel (for instance matching pairofdice)
    By Diceroller in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2006, 06:00 PM
  7. RE: How do I show the day and date in excel in the same cell
    By Ron Coderre in forum Excel General
    Replies: 0
    Last Post: 02-23-2006, 09:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1