Hello,
Please could you help me
I am trying to set up a cricket spreadsheet which was all fine until I came to the 'overs bowled' section.
The problem I have is that there are six balls per over.
I need excel to recognise that, for instance, when I enter '5.5', I mean '5 overs and five balls' rather than 'five and a half' which is of course what it thinks I mean.
Is there anyway of formating a cell so that it does not apply decimal rules, but allows me to calculate in sixths without using fractions.
any help would be much appreciated
many thanks
Mark
![]()
Bookmarks