Select <fraction> <up to two digits>.

--
Greetings from New Zealand

Bill K


"David Rose" <drose@compasscon.com> wrote in message
news:eCPoRH6PFHA.3716@TK2MSFTNGP14.phx.gbl...
>I am creating an employee time sheet, where the hours worked will be
>entered in increments as small as 15 minutes and be displayed as fractions.
>For example, I would like 2.5 hours to display as "2 1/2" and 4.25 hours to
>display as "4 1/4". When I choose "Fractions" in the cell formatting and
>select the fraction denominator as '4', 2.5 hours displays as 2 2/4, not 2
>1/2.
>
> How do I set the formatting to display as I want?
>
> TIA
> David
>