remove percent symbol on percentage formatted cells in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm trying to get a cell to have a percent format but not display the
percent symbol "%".

How can I do that? if at all.
 
It can surely be done, at the risk of confusing people who don't know
what they're looking at. In whatever percentage calculation you have,
multiply the result by 100, or at the end of the calculation add "*100"
( star one zero zero without the quotes).
 

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

Using Accounting Underlines with Percent Symbols 1
Combining Percent with Text 5
Formatting Columns of Percent Data 2
Access Test if value is less than percent 0
Average Formula Help 2
Lining up cells with % symbol to those without. 3
Setting an Icon Set conditional format for a single cell??? 4
Format Result of a Formula Combining Text & Numbers 3

Back
Top