How tp display fractions / custom number
 

(How) Can I set-up up a Custom number to display fractional fractions as in
this example:

Display 108.95 as 108 9.5/10
109.70 as 109 7/10

I can make it work for whole numbers as in the secon example by making a
Custom No as ?? ?/10, but cannot get it to show me decimals.

Any help would be greatly appreciated.

Regards,
Diane

How tp display fractions / custom number
 

Diane

I think you'll be limited to using

0 ??/100

as a custom format which will give you 108 95/100 say.

Hope this helps!

Richard


Diane wrote:
(How) Can I set-up up a Custom number to display fractional fractions as in
this example:

Display 108.95 as 108 9.5/10
109.70 as 109 7/10

I can make it work for whole numbers as in the secon example by making a
Custom No as ?? ?/10, but cannot get it to show me decimals.

Any help would be greatly appreciated.

Regards,
Diane

How tp display fractions / custom number
 

Try =TEXT(INT(A1),"#")&" "&TEXT(MOD(A1,1)*10,"#0.0")&"/10"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Diane" wrote in message
...
(How) Can I set-up up a Custom number to display fractional fractions as
in
this example:

Display 108.95 as 108 9.5/10
109.70 as 109 7/10

I can make it work for whole numbers as in the secon example by making a
Custom No as ?? ?/10, but cannot get it to show me decimals.

Any help would be greatly appreciated.

Regards,
Diane