New Posts For Thread: Clever ??https://community.betfair.com/general_betting/go/thread/view/94082/26630033/cleverhttp://www.michaelbach.de/ot/sze_silhouette/index.htmlhttps://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481861801#481861801Mon, 17 Jan 2011 04:41:10 -0600SPOTLIGHT VERDICT: FISHOUTOFWATER brings useful bumper form to the table and this big, scopey sort is the most promising runner in the field as things stand. Top Benefit and Major Payne are entitled to be on the premises.[Steven Boow]Ha!!https://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481779593#481779593SPOTLIGHT VERDICT: FISHOUTOFWATER brings useful bumper form to the table and this big, scopey sort is the most promising runner in the field as things stand. Top Benefit and Major Payne are entitled to be on the premises.[Steven Boow]Ha!!Sun, 16 Jan 2011 10:57:08 -0600Weight has a dramatic effect on tall horses .A common misconception is the larger animal will be superior where that is true in steady run events over a trip .The reverse is also true and the small horse with less weight will prevail.The stud book ishttps://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481587841#481587841Weight has a dramatic effect on tall horses .A common misconception is the larger animal will be superior where that is true in steady run events over a trip .The reverse is also true and the small horse with less weight will prevail.The stud book isFri, 14 Jan 2011 15:15:29 -0600Thanks for the help, Compound....yeah, i was aware about the auto formatting....just has the effect of changing odds to decimals rather than staying as fractions which i'd prefer but isnt a bigee.https://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481524761#481524761Thanks for the help, Compound....yeah, i was aware about the auto formatting....just has the effect of changing odds to decimals rather than staying as fractions which i'd prefer but isnt a bigee.Fri, 14 Jan 2011 04:45:11 -0600If you know how to insert a macro and macro enable the workbook this macro would do it for you ~Sub Datetoweight() Range("C1").Select Selection.EntireColumn.Insert Columns("C:C").Select Selection.NumberFormat = "0.0" Range("C1").Selecthttps://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481524449#481524449If you know how to insert a macro and macro enable the workbook this macro would do it for you ~Sub Datetoweight() Range("C1").Select Selection.EntireColumn.Insert Columns("C:C").Select Selection.NumberFormat = "0.0" Range("C1").SelectFri, 14 Jan 2011 04:39:58 -0600Btw, the silhouette would get it!https://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481521913#481521913Btw, the silhouette would get it!Fri, 14 Jan 2011 03:57:09 -0600There have been other threads on this issue which have been solved by other users ~ worth looking up and acting upon.If you still have trouble there are several fixes in excel that can be done.Better to fix the problem before importing by turning ofhttps://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481521561#481521561There have been other threads on this issue which have been solved by other users ~ worth looking up and acting upon.If you still have trouble there are several fixes in excel that can be done.Better to fix the problem before importing by turning ofFri, 14 Jan 2011 03:52:16 -0600I have a similar problem with fractional odds always getting changed into a date in Excel. With individual cells or a column of cells, you can go to format cells (click on format towards top right and then format cells at very bottom) and set it to 'https://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481521441#481521441I have a similar problem with fractional odds always getting changed into a date in Excel. With individual cells or a column of cells, you can go to format cells (click on format towards top right and then format cells at very bottom) and set it to 'Fri, 14 Jan 2011 03:50:14 -0600Maybe you could explain to me as i as am at huge loss when i copy and paste racecardds into excel and the weight comes up as a date.Tried formatting..Just cant find the answer in the book.Basic question for the like of yourself but if you could helphttps://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481519093#481519093Maybe you could explain to me as i as am at huge loss when i copy and paste racecardds into excel and the weight comes up as a date.Tried formatting..Just cant find the answer in the book.Basic question for the like of yourself but if you could helpFri, 14 Jan 2011 03:13:21 -0600Should have spent ny time in the class that you are in.Have saved that as a new little formulae as i am trying to learn excel.It might sound funny to you but for me it is much better than the book that i bought .Ecel for dummies.https://community.betfair.com/general_betting/go/thread/view/94082/26630033/clever?post_id=481516937#481516937Should have spent ny time in the class that you are in.Have saved that as a new little formulae as i am trying to learn excel.It might sound funny to you but for me it is much better than the book that i bought .Ecel for dummies.Fri, 14 Jan 2011 02:22:47 -0600