about fractions
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
|