Correct score market in Excel

[ddaann]

0-0,0-1,0-2,0,3 and any unquoted are only showing correctly, all other are in 5 digit forum (i.e 39144
insted of 1-0). Tried formating cells in different modes to no avail.

[Ian]

Format -> Cells - > Text

[GeorgeUK]

is this data coming in from BA that's going to a 5 digit number?

Excel is being helpful and converting something like 2-3 as a date (2nd march)
(or at least along those lines)

As Ian says, you need to convert the cells to text format before entering in the data.
Is it data you are entering to excel or BA?
I thought everything from BA came through as text (which was why it could display time as a negative value)

[ddaann]

I tried that mate, still the same problem, only 0-0,0-1.0-2 and 0-3 properly showing.

[ddaann]

Directly from excel to API BA. It has been working fine so far on numerous markets, it seems only correct score is being affected.
As I said, Itried all kind of different cell formats to no avail.

[Ian]

All I can say is that it works for me every time.