Converting Decimal to Fraction Text VBA

Hi Guys,

Is there any easy way to convert a decimal to a text fraction in vba.

In excel itself you can use e.g. =text(B5,"0/00"), however VBA doesn't support the function.
E.g. To32nd = To32nd & Text(extravar, "0/000") says undefined function Text.

Is there any easy way to do this?

Much Appreciated!

Hi,

Try one of the following:

Please Login or Register  to view this content.

Lewis

Hi thanks for those responses, they work well when referring to a decimal in a cell in the sheet, however I'm trying to apply it to output from a VBA calc, which I've stored the result of in extravar. Unfortunately they prove less effective in that situation.

Any thoughts on how to do that?

Try the following:

Please Login or Register  to view this content.

Lewis