Thread: Fractions
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Fractions

Hello,

I suggest to be *very* cautious with the fraction number format
# ??/?? (or similar):
http://sulprobil.com/html/nearest_rational_number.html

=TRUNC(ROUND(A2*64,0)/64,0)&" "&ABS(ROUND(MOD(ROUND(A2*64,0)/64,
(A2=0)+SIGN(A2))*64,0))&"/64"

Regards,
Bernd