New Posts For Thread: downloading P&L to excelhttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excelExcel novice here so please excuse what is probably an ignorant questionWhen i download the P&L I get a little green arrow in each entry and am unable to highlight entries and do an autosum. How do I get around this so I can sort the spreadsheet andBrilliant, now I got it. Thanks chapshttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428938#419428938Brilliant, now I got it. Thanks chapsFri, 18 Dec 2009 03:16:31 -0600Ok- click on the cell with the value in it, a little box comes up with an exclamation mark in it, now click on the exclamation mark, you get a menu, choose "conver to number".Now- you can do the above with all the relavent cells selected (just selecthttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428934#419428934Ok- click on the cell with the value in it, a little box comes up with an exclamation mark in it, now click on the exclamation mark, you get a menu, choose "conver to number".Now- you can do the above with all the relavent cells selected (just selectFri, 18 Dec 2009 03:11:38 -0600Sorry, highlight all the fields with the green triangle thingy, then next to one of them a yellow ! box should appear - click on this and choose Convert To Number, that should work....https://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428930#419428930Sorry, highlight all the fields with the green triangle thingy, then next to one of them a yellow ! box should appear - click on this and choose Convert To Number, that should work....Fri, 18 Dec 2009 03:11:28 -0600hmm, I'm probably being stupid here, but hovering my mouse over it doesn't provide any menu. And in excel i have a hovering cross and not an arrow head as usual?There's also a 1000 lines of data each with a green arrow, surely I don't roll over eachhttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428926#419428926hmm, I'm probably being stupid here, but hovering my mouse over it doesn't provide any menu. And in excel i have a hovering cross and not an arrow head as usual?There's also a 1000 lines of data each with a green arrow, surely I don't roll over eachFri, 18 Dec 2009 03:05:52 -0600Like Joel says- roll over the little green arrow and you get a special pop up menu, choose convert to number and the job's a good un.https://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428922#419428922Like Joel says- roll over the little green arrow and you get a special pop up menu, choose convert to number and the job's a good un.Fri, 18 Dec 2009 03:00:13 -0600I can highlight a column of numbers (my profits or losses) but can't then autosum them to provide a total or get anything meaningful by right or left clicking, the menu just comes up with cut, copy, insert, delete etchttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428918#419428918I can highlight a column of numbers (my profits or losses) but can't then autosum them to provide a total or get anything meaningful by right or left clicking, the menu just comes up with cut, copy, insert, delete etcFri, 18 Dec 2009 02:58:13 -0600which bit didn't work?https://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428914#419428914which bit didn't work?Fri, 18 Dec 2009 02:48:38 -0600thanks Joel, that didn't seem to work for me thohttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428910#419428910thanks Joel, that didn't seem to work for me thoFri, 18 Dec 2009 02:20:09 -0600You should be able to highlight them all, then click on one of those arrows (left click or right, cant remember) and choose convert to numberhttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428906#419428906You should be able to highlight them all, then click on one of those arrows (left click or right, cant remember) and choose convert to numberFri, 18 Dec 2009 01:14:40 -0600Excel novice here so please excuse what is probably an ignorant questionWhen i download the P&L I get a little green arrow in each entry and am unable to highlight entries and do an autosum. How do I get around this so I can sort the spreadsheet andhttps://community.betfair.com/general_betting/go/thread/view/94082/23481810/downloading-pl-to-excel?post_id=419428902#419428902Excel novice here so please excuse what is probably an ignorant questionWhen i download the P&L I get a little green arrow in each entry and am unable to highlight entries and do an autosum. How do I get around this so I can sort the spreadsheet andFri, 18 Dec 2009 00:52:54 -0600