Rational exansion of a decimal number

L

Leo

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

Niek Otten

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
B

Bernie Deitrick

Leo,

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

HTH,
Bernie
MS Excel MVP
 
Top