Format number to display % symbol smaller than onther text in cell

  • Thread starter Thread starter goss9394
  • Start date Start date
G

goss9394

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
 
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 %.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Than Symbols and calculations 0
# symbol appearing instead of typed text in a cell 1
Symbol fonts 2
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
Data Validation - want to use symbols, but list is in orig font 2
Date String To Serial 11
Custom number format #,##0.## yields extra '.' when formattingintegers 3
Automatic Symbol Insertion In Cell 1

Back
Top