Cant get name of a runner using BA spreadsheet

[ilovepizza82]

Hi

When i type in:
='Bet Angel'!B9:B10

I get this (check out the screenshot):
Why and how can i get it fixed ?
The reason i wanna do it this way coz i want to combine all of the worksheets and make a one containing all of the worksheets, only names and odds.

[ShaunWhite]

B9:B10 is range of cells that you're trying to put into one cell.

[ilovepizza82]

Yea i formatted the cells and seems to be ok now however as im still battling python connection to the spreadsheet i realized it wont do as python reads actual values and i dont think it understands when there is reference to another worksheet so i used INDEX function instead and I think it works...
HOWEVER Python doesnt seem to be able to read excell spreadsheet while its open and constantly, live updated ... I mean i cant get the odds (when changed) being updated in python.