How can I set a Microsoft Excel cell to base 6?

have you tried increasing your decimals?

You need the whole number of overs in base 10, but the mantissa to be in base 6

so use to separate cells and add them

to convert from base 10 to base 6 , you divide by 6 and take the remainder ; however you do not wish to retain values over 5 ( so effectively you need to be in modulo 6), so you will need to use a conditional statement which would increase the integer part by 1, each time you rolled passed 0 in the mantissa.

I should e-mail the bearded wonder on tms@bbc.co.uk, if i were you

If you simply format your cells to be number, 1 decimal point, this should correct your problem. I can't see the need to make it any more complicated by thinking of any rounding formulae or anything ese for that matter.

i attempted to re-create it, I made it into 2 columns (i anticipate that's what you have) and appeared after on the 2d, huge style column. It worked wonderful for me. in keeping with risk there replaced into mixture up with the column titles. i don't think of that's an enduring situation, yet to be secure, attempt returned with a clean workbook.

You could use the ROUND function - look this up in help for some examples.

=INT(A1/6)

and for the remaining overs

=MOD(A1,6)

where A1 is the total overs bowled