New Posts For Thread: excel help needed pleasehttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-pleasehow can u type in odds eg 3/1 and not appearing in date or year etc iv tried format cells but cant figure it thanxanyway rossoneri i really have to go i'm afraid.hope its what you need now.glhttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432328533#432328533anyway rossoneri i really have to go i'm afraid.hope its what you need now.glFri, 07 May 2010 14:17:13 -0500moongirl he hasn't got a problem with formatting anymorehttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432328293#432328293moongirl he hasn't got a problem with formatting anymoreFri, 07 May 2010 14:15:49 -0500after this you will have a table that looks like the one i posted earlier where the data is sorted by decimal odds in ascending order.https://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432328177#432328177after this you will have a table that looks like the one i posted earlier where the data is sorted by decimal odds in ascending order.Fri, 07 May 2010 14:15:13 -0500format cell (CTR+;1)--> texthttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432327937#432327937format cell (CTR+;1)--> textFri, 07 May 2010 14:14:09 -0500The atmosphere is electrichttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432327865#432327865The atmosphere is electricFri, 07 May 2010 14:13:45 -0500once you have a blank column a...click on the h of column h and the whole of the data in that column is selected.then use copy and just paste into the blank column aobviously you then have column a as decimal odds and you can sort this from low to hihttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432327837#432327837once you have a blank column a...click on the h of column h and the whole of the data in that column is selected.then use copy and just paste into the blank column aobviously you then have column a as decimal odds and you can sort this from low to hiFri, 07 May 2010 14:13:34 -0500right have you inserted a column in the sheet so that column a is now blank and b is sp odds, c is runners etc.. ?https://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432327217#432327217right have you inserted a column in the sheet so that column a is now blank and b is sp odds, c is runners etc.. ?Fri, 07 May 2010 14:10:07 -0500no the table was fine just the copying to col a is gettin me so after i copy i have it in text do i just highlight the price eg 2/1 and then move 2 a?https://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432326289#432326289no the table was fine just the copying to col a is gettin me so after i copy i have it in text do i just highlight the price eg 2/1 and then move 2 a?Fri, 07 May 2010 14:05:24 -0500after you've copied from massey and done the paste special...in column a you have text odds yes ?insert a column so that column a shifts over to the right.in the blank column copy the'sp decimal odds data' into the new blank column a.yhttps://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432325793#432325793after you've copied from massey and done the paste special...in column a you have text odds yes ?insert a column so that column a shifts over to the right.in the blank column copy the'sp decimal odds data' into the new blank column a.yFri, 07 May 2010 14:02:49 -0500forgive me anf ( after istanbul u owe me this much!!) im followin ur advice cant get it without manual tamperin how u copy a column when in text?https://community.betfair.com/horse_racing/go/thread/view/94102/23980193/excel-help-needed-please?post_id=432325013#432325013forgive me anf ( after istanbul u owe me this much!!) im followin ur advice cant get it without manual tamperin how u copy a column when in text?Fri, 07 May 2010 13:58:50 -0500