# Convert Fractional Odds To Decimals

• When exporting a set of historical sports results to Excel 2003 the numeric odds are converted to a date eg 7/2 changes to 07-Feb. Can this be prevented or adjusted to retain the original data.

Also if I may ask can the UK style odds be converted to a decimal style. Eg. 7/2 (UK) needs to be converted to 4.5 ( Decimal equivalent )

I trust this is clear as I feel out of my depth just posting this question.

• Re: Dates Convert To Numbers

Try formatting the cells to a Number format via Format>Cells-Number

• Re: Dates Convert To Numbers

Dave

Just tried that and the date 07-Feb changed to 39120. Does that mean anything ?

• Re: Dates Convert To Numbers

07-Feb IS a date and that number would be a serial number for the date. You need to format the receiving cells BEFORE the import, not after.

• Re: Dates Convert To Numbers

Dave

Followed your instructions but still get the serial code for the date. I feel I'm likely to end up wasting your time. I apologise.

• Re: Dates Convert To Numbers

Welcome to the forum!

Can you attach your workbook or a sample showing where you want odds converted?

• Re: Dates Convert To Numbers

Have you tried formatting the cell as Text? (Before import)

• Re: Dates Convert To Numbers

ByTheCringe2,

if I well understand what good2soft want to say is he's importing 7/2 and would like to have 7/2 or 3.5 in the cell and not the equivalent 7-Feb.

It happened something similar to me but the other way round: entering 1/2, 1/4 and 3/4 for 1-Feb, 1/3-April I got exactly 1/2, 1/4, 3/4 instead of my dates.
It's worth maybe to look under Tools->AutocorrectOptions ( Autocorrect Tab), to see if all setting are correct.

filippo

• Re: Dates Convert To Numbers

Yep, filippo, I have dug out the formula I use.

good2soft, As Mike says, pre-format the column to Text. Then paste your odds. This formula assumes they are in A1. Put this in B1 and fill down.

=IF(ISERROR(FIND("/",A1)),0,1+ROUND(LEFT(A1,FIND("/",A1)-1)/RIGHT(A1,LEN(A1)-FIND("/",A1)),3))

Come back if you need more help.

EDIT: ISERR changed to ISERROR.

• Re: Dates Convert To Numbers

Thanks for all the input. Must take timeout for an hour or so. Must go to the bank. Will respond to your suggestions upon my return.

• Re: Convert Fractional Odds To Decimals

ByTheCringe2 + filo65

Decimal conversion works fine.

Many thanks

• Re: Convert Fractional Odds To Decimals

filippo, good2soft & BTC2

Whenever a cell format is the default (General) and you input or import data into it, Excel well assume you want the the data either converted and/or the cell re-formatted to suit the input/import.

However, IF you pre-format the cell to any other format Excel will not re-format and only convert the input to suit the format chosen. So, if I pre-format a cell as Number and then input 7/2 it is immediately converted to the decimal equivalent of 3.5

There should be no need for formulas

• Re: Convert Fractional Odds To Decimals

Worth knowing, Dave, thanks. But 7/2 in fractional odds is actually 4.5 in decimal odds (I know, don't blame me, LOL) which would mean a bit of attention would be needed. That was a very old formula I found.

• Re: Convert Fractional Odds To Decimals

I guess that's my professional gambling career over with

• Re: Convert Fractional Odds To Decimals

BTC2,

I'm fascinated by the english peculiar way of calculating.::D

7/2 = 4.5? it's fantastic! It opens incredible business perspectives: you show a price, but you mean another ( at least here on the continent ).;)
Which format category should I look into? I searched in my german and english PC but I couldn't find any.

filippo

• Re: Convert Fractional Odds To Decimals

Well actually, filippo, it is the European (or continental) odds system that is strange! If you look here, you will see that the British system is the dear old fractional system. But it does get a bit unwieldy when you start talking 100/30, and the betting exchanges couldn't cope, so they all use the decimal system.

And then there are American odds - stranger still!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!