Is there a way with VBA to convert custom formatting into actual text. I have some numbers that are formatted as fractions, but the value itself is still a decimal. Is there a way to convert it to a text string so that contents of the cell is actually a fraction.

Ex: With my formatting 21.25 displays as 21-1/4 but the value of the cell is still 21.25. I need the actual contents of the cell to be 21-1/4.