Yep, I know how to do it 'manually': divide the fraction 'by itself' and add 1, e.g., 9/2 is 4.50 +1 = 5.50, but I need to convert over 3,000 of them in an Excel file and I'm only a basic Excel user, having no training, just experience.

The Excel file is in this format:<PRE>

A B C D E F G

Date Track Time Name Rating W or L SP

</PRE>

...so the question is how do I convert the contents of column G to decimal odds? I have a basic understanding of Excel and can follow instructions - can anyone help?

Thanks

Paul

## Auto Convert Fractional to Decimal in Excel?

I split the fractional odds into two columns, and then used a formula in a third column to "divide the fraction 'by itself', and then add one to the result". The fractional odd needed to be in Text format.

11/4 was in Column A, so by using Data -> Text To Column, the 11 and the 4 were split into columns A and B, and then the following formula was used in Column C:

=(A1/B1)+1

...which created 3.75 in column C.

[Technically =($A1/$B1)+1 was used so the 'relative reference' formula could be copied to the rest of the C column].

### auto convert

DeepJoy

There is an easier way. I just can't remember what it is at the moment !

I had something working once when i was copying some data with fractions from a web page into excel. I'll try and dig it up.

You learn something new every day dont you. I never knew about

Data --> Text to Columns !

There is an easier way. I just can't remember what it is at the moment !

I had something working once when i was copying some data with fractions from a web page into excel. I'll try and dig it up.

You learn something new every day dont you. I never knew about

Data --> Text to Columns !

### Re: Auto Convert Fractional to Decimal in Excel?

Hi Guys/Gals

You could try

Assuming your fraction is in column G

In column H you put "=DOLLAR(G7)" in one column

and in column i you put "=REPLACE(F7,1,1,"")+1" to get rid of the £ sign and add one to the odds

Hope this helps

Phil

You could try

Assuming your fraction is in column G

In column H you put "=DOLLAR(G7)" in one column

and in column i you put "=REPLACE(F7,1,1,"")+1" to get rid of the £ sign and add one to the odds

Hope this helps

Phil

### Re: auto convert

support wrote:You learn something new every day dont you. I never knew about

Data --> Text to Columns !

Neither did I until yesterday

### Re: Auto Convert Fractional to Decimal in Excel?

dibbles wrote:Hi Guys/Gals

You could try

Assuming your fraction is in column G

In column H you put "=DOLLAR(G7)" in one column

and in column i you put "=REPLACE(F7,1,1,"")+1" to get rid of the £ sign and add one to the odds

Hope this helps

Phil

Much appreciate the suggestion Phil, but if I do that, I end up with column I saying #VALUE!

I suspect my lack of structured training is showing here and the solution is easy...

### Re: Auto Convert Fractional to Decimal in Excel?

Sorry

Should read "=REPLACE(H7,1,1,"")+1"

Should work now

Phil

Should read "=REPLACE(H7,1,1,"")+1"

Should work now

Phil

### Re: Auto Convert Fractional to Decimal in Excel?

dibbles wrote:Sorry

Should read "=REPLACE(H7,1,1,"")+1"

Should work now

Phil

Thank you Phil that does indeed work now.

Regards

Dave

=(LEFT(G1,FIND("/",G1)-1)/MID(G1,FIND("/",1)+1,4))+1

So 9/2 becomes 9 and 2, then 9 is divided by 2, and finally 1 is added. Hope that helps. Sorry for the late reply, I only joined the forum today.

Paul

### Who is online

Users browsing this forum: Google [Bot] and 2 guests