On Tue, 28 Mar 2006 16:03:01 -0800, patrick
wrote:

I would like to display a compound fraction, but i only want the whole number
and the numerator of the fraction to be displayed.

For example:
5- 14/30
displayed as: 5- 14

thanks for any help
patrick

The value you display will be a text value. With the original number in H1:

=LEFT(TEXT(H1,"#""- ""??/30"),FIND("/",TEXT(H1,"#""- ""??/30"))-1)


--ron