![]() |
Format number to display % symbol smaller than onther text in cell
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 |
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 |
All times are GMT +1. The time now is 08:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com