https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-pleaseI am trying to convert a column of fractional odds into decimal odds but don't know how to. Is there an easy way to do this?When I take the odds from M/soft Works to Excel it shows either as 05-Feb for all sp's at 5/2. Others are shown below.05-Febhttps://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809206#420809206OK.Thanks.Tue, 09 Mar 2010 13:24:12 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809146#420809146No I am just playing with some download results from Raceform Interactive..Tue, 09 Mar 2010 09:06:14 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809134#420809134panicOut of curiosity are you downloading your data from horseracebase.com?Tue, 09 Mar 2010 08:33:49 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809130#420809130Thanks laylow, I really appreciate your help.Seeing how clever these formulas can be, it has got me thinking.Would it be possible to paste a comment in running into a cell such as:CHSD LDRS: RDN OVER2F OUTThen ask the formula to use a value of say 1Tue, 09 Mar 2010 08:19:41 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809126#420809126You can copy them using paste special, valuesTue, 09 Mar 2010 08:08:11 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809118#420809118:-)Great now I have this, thanks very much but I cannot seem to copy this new list of decimal prices and paste them either somewhere else on this excel sheet or into a new m/soft works database as it just shows the formula or #VALUEIs there a way I cTue, 09 Mar 2010 07:57:21 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809110#420809110I then copy this into an empty excel sheet and the odds change to:This is the crucial stage. Either format the column as text (right click, format cells,Text) before pasting the data into them.or use paste special unicode text (right click, paste spTue, 09 Mar 2010 07:39:33 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809102#420809102No I am rubbish at this sort of thing but don't give up on me :-)I need to be shown step by step if possible.If I could start again, I have a list of odds in Microsft Works which get shown as below.06/0405/0209/0402/0115/0802/0109/0407/0402/0113/08ITue, 09 Mar 2010 07:28:18 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809098#420809098I can now however get my odds to sit as normal in excel by formatting to Turkish date so they now look like below:that is why Smar tarse's code does work. The data has to text not a date.do you know how to run VBA code?Tue, 09 Mar 2010 07:16:04 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23531598/excel-help-please?post_id=420809094#420809094Thanks LayLow, I tried that but couldn't make it work. I can now however get my odds to sit as normal in excel by formatting to Turkish date so they now look like below:9/46/47/415/87/45/29/411/85/25/4Not sure how evens will work but don't worry. WitTue, 09 Mar 2010 07:11:57 -0600