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" <Leo@discussions.microsoft.com> wrote in message
news:883FA1F6-77E6-480A-B2E9-142C493DB0C7@microsoft.com...
> 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" <Leo@discussions.microsoft.com> wrote in message
news:883FA1F6-77E6-480A-B2E9-142C493DB0C7@microsoft.com...
> Usign Excel: Is there a mcro out there to retrun the ratioanl expansion of a
> decimal number?
> i.e., 0.75 == 3, 4