Rational exansion of a decimal number
 

Usign Excel: Is there a mcro out there to retrun the ratioanl expansion of a
decimal number?
i.e., 0.75 == 3, 4

=SUBSTITUTE(TEXT(A1,"?/?"),"/",",")

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Leo" wrote in message
...
Usign Excel: Is there a mcro out there to retrun the ratioanl expansion of
a
decimal number?
i.e., 0.75 == 3, 4

Leo,

You could format the cell as a fraction: 0.75 == 3/4

HTH,
Bernie
MS Excel MVP


"Leo" wrote in message
...
Usign Excel: Is there a mcro out there to retrun the ratioanl expansion of a
decimal number?
i.e., 0.75 == 3, 4