View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Format number to display % symbol smaller than onther text in cell

You'd have to change the number to text for this to happen.

Prefix the number with an apostrophe, then select *only* the % sign in the
formula bar.
Right click in the selection and choose "Format Cells", and then pick the
font size you want for the %.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
ups.com...
Hi all-

I would like the % symbol to appear smaller than the number in a cell
formatted for %.
Is there any way to do this?

Thanks
-goss