Excel formatting show percent value without percent sign

Question

In Excel, I want to display figures like 0.95 as 95; formatting them as% displays 95%; but I want to remove the percent indicator. Is there anything I can do for this in "Custom Formatting"?

Answer 1

You can change how it appears while maintaining its fundamental worth.

This is a clumsy technique.

1. Enable Wrap Text on the cells.

2. You want a Custom Format.

3. Enter the custom format as follows:

1. Enter 0.00

2. While holding down Alt, enter 0010. This will put in a line break

3. Put in the %.

4. Hit OK

The number will be converted to a percentage, but the percentage will appear on the second line. The cell will only display the number if it is set to wrap and is only tall enough to display one line.

The underlying number will remain the .xxxx and not that of 100 * .xxxx