We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
Excel novice here so please excuse what is probably an ignorant question
When 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 and total the P&L for various segments? Any help appreciated..
When 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 and total the P&L for various segments? Any help appreciated..
sort by:
Show
per page
Replies: 9
|
By:
You should be able to highlight them all, then click on one of those arrows (left click or right, cant remember) and choose convert to number
|
|
By:
thanks Joel, that didn't seem to work for me tho
|
|
By:
which bit didn't work?
|
|
By:
I 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 etc
|
|
By:
Like 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.
|
|
By:
hmm, 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 each one? |
|
By:
Sorry, 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....
|
|
By:
Ok- 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 select the whole column) and it'll do the whole lot at once. |
|
By:
Brilliant, now I got it. Thanks chaps
|