zack, thanks! it worked great! although i ended up needing to round
(A1-INT(A1))*30
for some reason without the round function I would get 5-1.9999999999999
instead of 5-2

but it got me where i needed to be

Thank You
patrick
"Zack Barresse" wrote:

Hello Patrick,

You must use a formula for this as it can't be done with formatting alone.
You could use something like this ...

=INT(A1)&" - "&(A1-INT(A1))*30

...assuming your number was a valid number and resided in A1, and that you
always wanted it expressed in n/30.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"patrick" wrote in message
...
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