MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Mixed font size


Posted by Gerald Marshall on January 30, 2002 1:39 PM

I have a figure in a particular cell that is formatted to display numbers in fractions e.g 5 6/12
Is there any way to format the number so that the fraction part of the number is font size 8 and the whole number is font size 10


Posted by JACK IN THE UK on January 30, 2002 3:34 PM

Hi--
As fraction, i have tried before and never solved this but inm sure you found in decimal you can mix the size but hang on....

Jack

Posted by JACK IN THE UK on January 30, 2002 3:44 PM

A fix convert to text with ' at the start and then select the fraction and change size HTH [NT]

Posted by Gerald Marshall on January 31, 2002 11:59 AM

Re: A fix convert to text with ' at the start and then select the fraction and change size HTH [NT]

Hi Jack

Thanks very much for your help, much appreciated

Gerald (Northern Ireland)