Hi Guys & Girls,
I am trying to set up a spreadsheet to enter cricket stats.
It's been fine until I come to 'number of overs bowled'
The problem is that there are only six balls in an over.

I need excel to recognise that for instance when i enter '5.5' it means '5 overs and 5 balls' not '5 and a half' overs.

I am assuming that i need to change the cell properties from calculating in decimal to calculating in groups of six.

At the moment as a workaround I am just entering 'balls bowled' instead of 'overs bowled'

Any help would be much appreciated

thanks
Mark